<!DOCTYPE html>
<html lang="en" class="svg no-js">
<head>
    <meta charset="utf-8" />
    <!--[if IE ]>
    <meta http-equiv="X-UA-Compatible" content="IE=Edge,chrome=1" />
    <![endif]-->
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta name="Language" content="en">

    <title>MySQL :: MySQL 8.0 Reference Manual :: 4.5.6 mysqlpump — A Database Backup Program</title>
    <link rel="stylesheet" media="all" href="css/main-20190125.min.css" />
            <link rel="stylesheet" media="all" href="css/docs-20190125.min.css" />
    
    
    <link rel="stylesheet" media="print" href="css/print-20190125.min.css" />

    
    
    
    
            <link rel="contents" href="index.html" title="MySQL 8.0 Reference Manual" />
<link rel="start" href="index.html" title="MySQL 8.0 Reference Manual" />
<link rel="prev" href="mysqlimport.html" title="4.5.5 mysqlimport &mdash; A Data Import Program" />
<link rel="next" href="mysqlshow.html?ff=nopfpls" title="4.5.7 mysqlshow &mdash; Display Database, Table, and Column Information" />
<link rel="up" href="programs-client.html" title="4.5 MySQL Client Programs" />

    
    <link rel="shortcut icon" href="favicon.ico" />
    <script>(function(H){ H.className=H.className.replace(/\bno-js\b/,'js') })(document.documentElement)</script>
    <script src="js/site-20181120.min.js"></script>

    
    
    
    <!--[if lt IE 9]>
        <script src="https://labs.mysql.com/common/js/polyfills/html5shiv-printshiv-3.7.2.min.js"></script>
        <script src="https://labs.mysql.com/common/js/polyfills/respond-1.4.2.min.js"></script>
    <![endif]-->
        <!--[if IE 9]>
        <style>#docs-sidebar-toc { box-sizing: content-box; }</style>
    <![endif]-->
    </head>

<body class="no-sidebar full-page dev">
<div class="page-wrapper">
    <header>

                        <a href="https://dev.mysql.com/" aria-label="Home" title="MySQL" id="l1-home-link"></a>
        
        <div id="l1-nav-container">
            <div id="l1-line1">
                <div id="l1-auth-links">
                    <a href="https://www.mysql.com/about/contact/"><b>Contact MySQL</b></a>
                    <span id="l1-contact-separator">&nbsp;|&nbsp;</span>
                    <span id="l1-contact-separator-br"><br /></span>
                                             <a href="https://dev.mysql.com/auth/login/?dest=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F8.0%2Fen%2Fmysqlpump.html">Login</a> &nbsp;|&nbsp;
                         <a href="https://dev.mysql.com/auth/register/">Register</a>
                                    </div>
                <div id="l1-lhs">
                    <div id="l1-slogan">
                        The world's most popular open source database
                    </div>
                    <div id="l1-search-box">
                        <form id="l1-search-form" method="get" action="https://www.oracle.com/search/results">
                        <input type="hidden" name="cat" value="mysql" />
                        <input type="hidden" name="Ntk" value="SI-ALL5" />
                        <input id="l1-search-input" type="search" class="icon-search" placeholder="Search" aria-label="Search" name="Ntt" />
                        </form>
                    </div>
                </div>
            </div>
            <div id="l1-line2">
                <div class="social-icons">
                    <a aria-label="Join us on Facebook" title="Join us on Facebook" href="http://www.facebook.com/mysql"><span class="icon-facebook"></span></a>
                    <a aria-label="Follow us on Twitter" title="Follow us on Twitter" href="https://twitter.com/mysql"><span class="icon-twitter"></span></a>
                    <a aria-label="Follow us on LinkedIn" title="Follow us on LinkedIn" href="https://www.linkedin.com/company/mysql"><span class="icon-linkedin"></span></a>
                    <a aria-label="Visit our YouTube channel" title="Visit our YouTube channel" href="http://www.youtube.com/mysqlchannel"><span class="icon-youtube"></span></a>
                </div>
                <ul id="l1-nav">
                    <li>
                        <a href="https://www.mysql.com/"><!-- <span class="icon-sakila"></span>  -->MySQL.com</a>
                    </li><li>
                        <a href="https://www.mysql.com/downloads/"><!-- <span class="icon-download-thin"></span>  -->Downloads</a>
                    </li><li class="active">
                        <a href="/doc/"><!-- <span class="icon-books"></span>  -->Documentation</a>
                    </li><li>
                        <a href="/"><!-- <span class="icon-code"></span>  -->Developer Zone</a>
                    </li>                </ul>
            </div>
        </div>
        <div id="sub-header">
            <div id="l2-nav-container">
                <div id="l2-nav-toggle">
                    <span class="icon-three-bars"></span>
                </div>
                                                                                        <a class="button nav-button-3" href="/"><span class="icon-code"></span> Developer Zone</a>
                                                                                                                                    <a class="button nav-button-2" href="https://www.mysql.com/downloads/"><span class="icon-download-thin"></span> Downloads</a>
                                                                                                <a class="button nav-button-1" href="https://www.mysql.com/"><span class="icon-sakila"></span> MySQL.com</a>
                                                                        <div id="l2-search-toggle">
                    <span class="icon-search"></span>
                </div>
                <div id="l2-site-icon">
                                                                                                                                                                                                    <span class="icon-books"></span>
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        </div>
                <div id="l1-section-title">
                    <span id="l1-section-label">
                        <a href="/doc/">Documentation</a>
                    </span>
                </div>
                <nav>
                    

<ul id="l2-nav">
            	<li class="active"><a class="active " href="/doc/refman/en/">MySQL Server</a>
    			</li>
	        	<li class=""><a  href="/doc/index-enterprise.html">MySQL Enterprise</a>
    			</li>
	        	<li class=""><a  href="/doc/workbench/en/">Workbench</a>
    			</li>
	        	<li class=""><a  href="/doc/en/mysql-innodb-cluster-userguide.html">InnoDB Cluster</a>
    			</li>
	        	<li class=""><a  href="/doc/index-cluster.html">MySQL NDB Cluster</a>
    			</li>
	        	<li class=""><a  href="/doc/index-connectors.html">Connectors</a>
    			</li>
	        	<li class=" last"><a  href="/doc/index-other.html">More</a>
    			</li>
	                        <li class="other-section"><a href="https://www.mysql.com/">MySQL.com</a></li>
                            <li class="other-section"><a href="https://www.mysql.com/downloads/">Downloads</a></li>
                                        <li class="other-section"><a href="/">Developer Zone</a></li>
            </ul>
                </nav>
            </div>
            <div id="l3-search-container"></div>
            <div id="top-orange"><span id="section-nav">Section Menu: &nbsp; </span></div>
        </div>
    </header>
        <div id="page">
                        <div role="main" id="main">

            
                
            
<div>
    <div id="docs-sidebar-toc" class="">
    <div id="docs-toc-inner">
        <div class="docs-sidebar-header" id="docs-nav-header">
            <a class="docs-show-hide-nav" id="docs-hide-nav" href="" title="Hide Sidebar" aria-label="Hide Sidebar"><span class="icon-arrow-small-left"></span></a>
            <div class="docs-nav-links">
                                    
    <a href="mysqlimport.html"
        aria-label="Previous" title="Previous: mysqlimport — A Data Import Program"><span
        class="icon-chevron-left"></span></a>
<a href="index.html" aria-label="Start" title="Start"><span class="icon-book-open"></span></a>
        <a aria-label="Up" href="programs-client.html" title="Up: MySQL Client Programs"><span class="icon-chevron-up"></span></a>
    <a href="mysqlshow.html" aria-label="Next"
        title="Next: mysqlshow — Display Database, Table, and Column Information"><span
        class="icon-chevron-right"></span></a>
                            </div>
        </div>
                    
<div id="docs-sidebar-search-container">
    <div id="docs-sidebar-search-box">
        <form method="get" action="/mysql-manual/search-page">
            <input type="hidden" name="d" id="d" value="201" />
            <input type="hidden" name="p" id="p" value="1" />
            <input type="text" name="keyword" id="q" title="Search this Manual"
                value=""
                style="color: #bbb;"
                onfocus=""
                onblur="" />

            <button class="docs-sidebar-search-btn" aria-label="Search" title="Search" type="submit">
                <span class="icon-search"></span>
            </button>
        </form>
    </div>
</div>
                <div class="docs-sidebar-nav">
            <a class="docs-icon-home" href="/doc/"><span class="icon-home"></span>Documentation Home</a><hr />
            <div class="docs-sidebar-mtitle">MySQL 8.0 Reference Manual</div>
            <nav class="doctoc" id="doc-201">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="preface.html">Preface and Legal Notices</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="introduction.html">General Information</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="installing.html">Installing and Upgrading MySQL</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="tutorial.html">Tutorial</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable  loaded" aria-label="Subnav" href=""><span class="icon-chevron-down"></span></a></div><div class="docs-sidebar-nav-link"><a href="programs.html">MySQL Programs</a></div></div>                        <div class="docs-submenu">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="programs-overview.html">Overview of MySQL Programs</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable  loaded" aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="programs-using.html">Using MySQL Programs</a></div></div>                        <div class="docs-submenu hidden">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="invoking-programs.html">Invoking MySQL Programs</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable  loaded" aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="program-options.html">Specifying Program Options</a></div></div>                        <div class="docs-submenu hidden">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="command-line-options.html">Using Options on the Command Line</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="option-files.html">Using Option Files</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="option-file-options.html">Command-Line Options that Affect Option-File Handling</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="option-modifiers.html">Program Option Modifiers</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="program-variables.html">Using Options to Set Program Variables</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="option-defaults-equals.html">Option Defaults, Options Expecting Values, and the = Sign</a></div></div>                    </li>
        </ul>
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="connection-options.html">Command Options for Connecting to the Server</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="connecting.html">Connecting to the MySQL Server Using Command Options</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="connecting-using-uri-or-key-value-pairs.html">Connecting to the Server Using URI-Like Strings or Key-Value Pairs</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="connection-compression-control.html">Connection Compression Control</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="setting-environment-variables.html">Setting Environment Variables</a></div></div>                    </li>
        </ul>
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable  loaded" aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="programs-server.html">MySQL Server and Server-Startup Programs</a></div></div>                        <div class="docs-submenu hidden">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysqld.html">mysqld — The MySQL Server</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysqld-safe.html">mysqld_safe — MySQL Server Startup Script</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysql-server.html">mysql.server — MySQL Server Startup Script</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysqld-multi.html">mysqld_multi — Manage Multiple MySQL Servers</a></div></div>                    </li>
        </ul>
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable  loaded" aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="programs-installation.html">MySQL Installation-Related Programs</a></div></div>                        <div class="docs-submenu hidden">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="comp-err.html">comp_err — Compile MySQL Error Message File</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysql-secure-installation.html">mysql_secure_installation — Improve MySQL Installation Security</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysql-ssl-rsa-setup.html">mysql_ssl_rsa_setup — Create SSL/RSA Files</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysql-tzinfo-to-sql.html">mysql_tzinfo_to_sql — Load the Time Zone Tables</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysql-upgrade.html">mysql_upgrade — Check and Upgrade MySQL Tables</a></div></div>                    </li>
        </ul>
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable  loaded" aria-label="Subnav" href=""><span class="icon-chevron-down"></span></a></div><div class="docs-sidebar-nav-link"><a href="programs-client.html">MySQL Client Programs</a></div></div>                        <div class="docs-submenu">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable  loaded" aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="mysql.html">mysql — The MySQL Command-Line Client</a></div></div>                        <div class="docs-submenu hidden">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysql-command-options.html">mysql Client Options</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysql-commands.html">mysql Client Commands</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysql-logging.html">mysql Client Logging</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysql-server-side-help.html">mysql Client Server-Side Help</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysql-batch-commands.html">Executing SQL Statements from a Text File</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysql-tips.html">mysql Client Tips</a></div></div>                    </li>
        </ul>
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysqladmin.html">mysqladmin — Client for Administering a MySQL Server</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysqlcheck.html">mysqlcheck — A Table Maintenance Program</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysqldump.html">mysqldump — A Database Backup Program</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysqlimport.html">mysqlimport — A Data Import Program</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link current"><a href="mysqlpump.html">mysqlpump — A Database Backup Program</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysqlshow.html">mysqlshow — Display Database, Table, and Column Information</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysqlslap.html">mysqlslap — Load Emulation Client</a></div></div>                    </li>
        </ul>
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable  loaded" aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="programs-admin-utils.html">MySQL Administrative and Utility Programs</a></div></div>                        <div class="docs-submenu hidden">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="ibd2sdi.html">ibd2sdi — InnoDB Tablespace SDI Extraction Utility</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innochecksum.html">innochecksum — Offline InnoDB File Checksum Utility</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="myisam-ftdump.html">myisam_ftdump — Display Full-Text Index information</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable  loaded" aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="myisamchk.html">myisamchk — MyISAM Table-Maintenance Utility</a></div></div>                        <div class="docs-submenu hidden">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="myisamchk-general-options.html">myisamchk General Options</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="myisamchk-check-options.html">myisamchk Check Options</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="myisamchk-repair-options.html">myisamchk Repair Options</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="myisamchk-other-options.html">Other myisamchk Options</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="myisamchk-table-info.html">Obtaining Table Information with myisamchk</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="myisamchk-memory.html">myisamchk Memory Usage</a></div></div>                    </li>
        </ul>
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="myisamlog.html">myisamlog — Display MyISAM Log File Contents</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="myisampack.html">myisampack — Generate Compressed, Read-Only MyISAM Tables</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysql-config-editor.html">mysql_config_editor — MySQL Configuration Utility</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable  loaded" aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="mysqlbinlog.html">mysqlbinlog — Utility for Processing Binary Log Files</a></div></div>                        <div class="docs-submenu hidden">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysqlbinlog-hexdump.html">mysqlbinlog Hex Dump Format</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysqlbinlog-row-events.html">mysqlbinlog Row Event Display</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysqlbinlog-backup.html">Using mysqlbinlog to Back Up Binary Log Files</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysqlbinlog-server-id.html">Specifying the mysqlbinlog Server ID</a></div></div>                    </li>
        </ul>
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysqldumpslow.html">mysqldumpslow — Summarize Slow Query Log Files</a></div></div>                    </li>
        </ul>
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable  loaded" aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="programs-development.html">MySQL Program Development Utilities</a></div></div>                        <div class="docs-submenu hidden">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysql-config.html">mysql_config — Display Options for Compiling Clients</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="my-print-defaults.html">my_print_defaults — Display Options from Option Files</a></div></div>                    </li>
        </ul>
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable  loaded" aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="programs-miscellaneous.html">Miscellaneous Programs</a></div></div>                        <div class="docs-submenu hidden">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="lz4-decompress.html">lz4_decompress — Decompress mysqlpump LZ4-Compressed Output</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="perror.html">perror — Display MySQL Error Message Information</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="zlib-decompress.html">zlib_decompress — Decompress mysqlpump ZLIB-Compressed Output</a></div></div>                    </li>
        </ul>
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="environment-variables.html">MySQL Environment Variables</a></div></div>                    </li>
        </ul>
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="server-administration.html">MySQL Server Administration</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="security.html">Security</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="backup-and-recovery.html">Backup and Recovery</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="optimization.html">Optimization</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="language-structure.html">Language Structure</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="charset.html">Character Sets, Collations, Unicode</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="data-types.html">Data Types</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="functions.html">Functions and Operators</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="sql-syntax.html">SQL Statement Syntax</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="data-dictionary.html">MySQL Data Dictionary</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="innodb-storage-engine.html">The InnoDB Storage Engine</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="storage-engines.html">Alternative Storage Engines</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="replication.html">Replication</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="group-replication.html">Group Replication</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysql-shell-userguide.html">MySQL Shell</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="document-store.html">Using MySQL as a Document Store</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="mysql-innodb-cluster-userguide.html">InnoDB Cluster</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="mysql-cluster.html">MySQL NDB Cluster 8.0</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="partitioning.html">Partitioning</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="stored-objects.html">Stored Objects</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="information-schema.html">INFORMATION_SCHEMA Tables</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="performance-schema.html">MySQL Performance Schema</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="sys-schema.html">MySQL sys Schema</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="connectors-apis.html">Connectors and APIs</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="extending-mysql.html">Extending MySQL</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="mysql-enterprise.html">MySQL Enterprise Edition</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="workbench.html">MySQL Workbench</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="faqs.html">MySQL 8.0 Frequently Asked Questions</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="error-handling.html">Errors, Error Codes, and Common Problems</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="restrictions.html">Restrictions and Limits</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="indexes.html">Indexes</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="glossary.html">MySQL Glossary</a></div></div>                    </li>
        </ul>
                            </nav>
        </div>

        
<a class="docs-sidebar-section" href=""><span class="icon-related"></span>
    <span class="text">Related Documentation</span></a>
<div class="docs-sidebar-accordian open">
    <div class="text">
        <a href="/doc/relnotes/mysql/8.0/en/">MySQL 8.0 Release Notes</a><br />
        <a href="/doc/dev/mysql-server/latest/">MySQL 8.0 Source Code Documentation</a><br />
        </div>
</div>

    <a class="docs-sidebar-section" href=""><span class="icon-download-thin"></span>
        <span class="text">
            Download
                            this Manual
                    </span>
    </a>
    <div class="docs-sidebar-accordian open">
        <div class="text">
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.pdf">PDF (US Ltr)</a>
            - 46.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.a4.pdf">PDF (A4)</a>
            - 46.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-ref-manual-8.0-en-pdf-1-20190611.noarch.rpm">PDF (RPM)</a>
            - 41.5Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.html-chapter.tar.gz">HTML Download (TGZ)</a>
            - 10.6Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.html-chapter.zip">HTML Download (Zip)</a>
            - 10.6Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-ref-manual-8.0-en-html-chapter-1-20190611.noarch.rpm">HTML Download (RPM)</a>
            - 9.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.man-gpl.tar.gz">Man Pages (TGZ)</a>
            - 220.4Kb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.man-gpl.zip">Man Pages (Zip)</a>
            - 325.8Kb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-8.0.info.gz">Info (Gzip)</a>
            - 4.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-8.0.info.zip">Info (Zip)</a>
            - 4.1Mb<br />
                    </div>
    </div>

<a class="docs-sidebar-section" href=""><span class="icon-book"></span>
    <span class="text">Excerpts from this Manual</span></a>
<div class="docs-sidebar-accordian">
    <div class="text">
                <a href="/doc/mysql-backup-excerpt/8.0/en/">MySQL Backup and Recovery</a><br />
                <a href="/doc/mysql-g11n-excerpt/8.0/en/">MySQL Globalization</a><br />
                <a href="/doc/mysql-infoschema-excerpt/8.0/en/">MySQL Information Schema</a><br />
                <a href="/doc/mysql-installation-excerpt/8.0/en/">MySQL Installation Guide</a><br />
                <a href="/doc/mysql-security-excerpt/8.0/en/">Security in MySQL</a><br />
                <a href="/doc/mysql-startstop-excerpt/8.0/en/">Starting and Stopping MySQL</a><br />
                <a href="/doc/mysql-linuxunix-excerpt/8.0/en/">MySQL and Linux/Unix</a><br />
                <a href="/doc/mysql-windows-excerpt/8.0/en/">MySQL and Windows</a><br />
                <a href="/doc/mysql-osx-excerpt/8.0/en/">MySQL and OS X</a><br />
                <a href="/doc/mysql-solaris-excerpt/8.0/en/">MySQL and Solaris</a><br />
                <a href="/doc/mysql-sourcebuild-excerpt/8.0/en/">Building MySQL from Source</a><br />
                <a href="/doc/mysql-reslimits-excerpt/8.0/en/">MySQL Restrictions and Limitations</a><br />
                <a href="/doc/mysql-partitioning-excerpt/8.0/en/">MySQL Partitioning</a><br />
                <a href="/doc/mysql-secure-deployment-guide/8.0/en/">MySQL Secure Deployment Guide</a><br />
                <a href="/doc/mysql-tutorial-excerpt/8.0/en/">MySQL Tutorial</a><br />
                <a href="/doc/mysql-perfschema-excerpt/8.0/en/">MySQL Performance Schema</a><br />
                <a href="/doc/mysql-replication-excerpt/8.0/en/">MySQL Replication</a><br />
                <a href="/doc/mysql-repo-excerpt/8.0/en/">Using the MySQL Yum Repository</a><br />
            </div>
</div>

        <br /><span id="wkr"><br /></span>
    </div>
    </div>

    <div id="docs-main" class="has-toc">
    <div id="docs-main-inner">

                <div class="right" id="docs-version-nav">
            <a href="" id="docs-version-nav-toggle">version 8.0
            <span class="icon-chevron-down"></span></a>
            <div id="docs-version-list">
                                                                                            <a                         href="/doc/refman/5.7/en/mysqlpump.html">
                        5.7
                                            </a><br />
                                                                            <a                         class="tooltip-left"
                        data-tooltip="The page you are viewing does not exist in version 5.6.
                        This link will take you to the Table of Contents."
                                                href="/doc/refman/5.6/en/">
                        5.6
                                            </a><br />
                                                                            <a                         class="tooltip-left"
                        data-tooltip="The page you are viewing does not exist in version 5.5.
                        This link will take you to the Table of Contents."
                                                href="/doc/refman/5.5/en/">
                        5.5
                                            </a><br />
                                                                        <div id="docs-version-nav-lang">
                                                                                                                                                    <a                                     class="tooltip-left"
                                    data-tooltip="The page you are viewing does not exist in version
                                    5.6 (JA).
                                    This link will take you to the Table of Contents."
                                                                        href="/doc/refman/5.6/ja/">
                                    5.6&nbsp;
                                                                            Japanese
                                                                    </a><br />
                                                                                            </div>
                            </div>
        </div>
        
        <div id="docs-show-nav" class="left hidden" style="margin-right: 15px;">
            <a class="docs-show-hide-nav" href="" aria-label="Show Sidebar"
                title="Show Sidebar"><span class="icon-arrow-small-right"></span></a>
        </div>

                        <div id="docs-breadcrumbs">
            <a href="/doc/refman/8.0/en/">MySQL 8.0 Reference Manual</a> &nbsp;/&nbsp;
                            <span id="breadcrumbs-link"><a href="" id="show-breadcrumbs">...</a> &nbsp;/&nbsp;</span>
                <span class="hidden" id="hidden-breadcrumbs">
                                                        <a href="programs.html">MySQL Programs</a> &nbsp;/&nbsp;
                                                            <a href="programs-client.html">MySQL Client Programs</a> &nbsp;/&nbsp;
                                                                                        </span>
                                        mysqlpump — A Database Backup Program
                                    </div>
        
        <div id="docs-body">
        
<div class="section">

<div class="titlepage">
<div>
<div>
<h3 class="title"><a name="mysqlpump"></a>4.5.6 <span class="command"><strong>mysqlpump</strong></span> — A Database Backup Program</h3>

</div>

</div>

</div>
<a class="indexterm" name="idm139663284239424"></a><a class="indexterm" name="idm139663284238480"></a><a class="indexterm" name="idm139663284237120"></a><a class="indexterm" name="idm139663284235760"></a><a class="indexterm" name="idm139663284234400"></a>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><a class="xref" href="mysqlpump.html#mysqlpump-syntax" title="mysqlpump Invocation Syntax">mysqlpump Invocation Syntax</a></p></li><li class="listitem"><p><a class="xref" href="mysqlpump.html#mysqlpump-option-summary" title="mysqlpump Option Summary">mysqlpump Option Summary</a></p></li><li class="listitem"><p><a class="xref" href="mysqlpump.html#mysqlpump-options" title="mysqlpump Option Descriptions">mysqlpump Option Descriptions</a></p></li><li class="listitem"><p><a class="xref" href="mysqlpump.html#mysqlpump-filtering" title="mysqlpump Object Selection">mysqlpump Object Selection</a></p></li><li class="listitem"><p><a class="xref" href="mysqlpump.html#mysqlpump-parallelism" title="mysqlpump Parallel Processing">mysqlpump Parallel Processing</a></p></li><li class="listitem"><p><a class="xref" href="mysqlpump.html#mysqlpump-restrictions" title="mysqlpump Restrictions">mysqlpump Restrictions</a></p></li></ul>
</div>
<p>
        The <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> client utility performs
        <a class="link" href="glossary.html#glos_logical_backup" title="logical backup">logical backups</a>,
        producing a set of SQL statements that can be executed to
        reproduce the original database object definitions and table
        data. It dumps one or more MySQL databases for backup or
        transfer to another SQL server.
      </p><p>
        <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> features include:
</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p>
            Parallel processing of databases, and of objects within
            databases, to speed up the dump process
          </p></li><li class="listitem"><p>
            Better control over which databases and database objects
            (tables, stored programs, user accounts) to dump
          </p></li><li class="listitem"><p>
            Dumping of user accounts as account-management statements
            (<a class="link" href="create-user.html" title="13.7.1.3 CREATE USER Syntax"><code class="literal">CREATE USER</code></a>,
            <a class="link" href="grant.html" title="13.7.1.6 GRANT Syntax"><code class="literal">GRANT</code></a>) rather than as inserts
            into the <code class="literal">mysql</code> system database
          </p></li><li class="listitem"><p>
            Capability of creating compressed output
          </p></li><li class="listitem"><p>
            Progress indicator (the values are estimates)
          </p></li><li class="listitem"><p>
            For dump file reloading, faster secondary index creation for
            <code class="literal">InnoDB</code> tables by adding indexes after
            rows are inserted
</p></li></ul>
</div>
<div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
<div class="admon-title">
Note
</div>
<p>
          <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> uses MySQL features introduced in
          MySQL 5.7, and thus assumes use with MySQL 5.7 or higher.
</p>
</div>
<p>
        <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> requires at least the
        <a class="link" href="privileges-provided.html#priv_select"><code class="literal">SELECT</code></a> privilege for dumped
        tables, <a class="link" href="privileges-provided.html#priv_show-view"><code class="literal">SHOW VIEW</code></a> for dumped
        views, <a class="link" href="privileges-provided.html#priv_trigger"><code class="literal">TRIGGER</code></a> for dumped
        triggers, and <a class="link" href="privileges-provided.html#priv_lock-tables"><code class="literal">LOCK TABLES</code></a> if the
        <a class="link" href="mysqlpump.html#option_mysqlpump_single-transaction"><code class="option">--single-transaction</code></a> option is
        not used. The <a class="link" href="privileges-provided.html#priv_select"><code class="literal">SELECT</code></a> privilege on
        the <code class="literal">mysql</code> system database is required to dump
        user definitions. Certain options might require other privileges
        as noted in the option descriptions.
      </p><p>
        To reload a dump file, you must have the privileges required to
        execute the statements that it contains, such as the appropriate
        <code class="literal">CREATE</code> privileges for objects created by
        those statements.
</p>
<div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">

<div class="admon-title">
Note
</div>
<p>
          A dump made using PowerShell on Windows with output
          redirection creates a file that has UTF-16 encoding:
        </p><pre class="programlisting copytoclipboard line-numbers language-terminal one-line"><code class="language-terminal">shell&gt; mysqlpump [options] &gt; dump.sql</code></pre><p>
          However, UTF-16 is not permitted as a connection character set
          (see <a class="xref" href="charset-connection.html" title="10.4 Connection Character Sets and Collations">Section 10.4, “Connection Character Sets and Collations”</a>), so the dump file
          will not load correctly. To work around this issue, use the
          <code class="option">--result-file</code> option, which creates the
          output in ASCII format:
        </p><pre class="programlisting copytoclipboard line-numbers language-terminal one-line"><code class="language-terminal">shell&gt; mysqlpump [options] --result-file=dump.sql</code></pre>
</div>
<h4><a name="mysqlpump-syntax"></a>mysqlpump Invocation Syntax</h4>
<p>
        By default, <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> dumps all databases
        (with certain exceptions noted in
        <a class="xref" href="mysqlpump.html#mysqlpump-restrictions" title="mysqlpump Restrictions">mysqlpump Restrictions</a>). To specify this
        behavior explicitly, use the
        <a class="link" href="mysqlpump.html#option_mysqlpump_all-databases"><code class="option">--all-databases</code></a> option:
      </p><pre class="programlisting copytoclipboard line-numbers language-terminal one-line"><code class="language-terminal">shell&gt; mysqlpump --all-databases</code></pre><p>
        To dump a single database, or certain tables within that
        database, name the database on the command line, optionally
        followed by table names:
      </p><pre class="programlisting copytoclipboard line-numbers language-terminal"><code class="language-terminal">shell&gt; mysqlpump <em class="replaceable">db_name</em>
shell&gt; mysqlpump <em class="replaceable">db_name tbl_name1 tbl_name2 ...</em></code></pre><p>
        To treat all name arguments as database names, use the
        <a class="link" href="mysqlpump.html#option_mysqlpump_databases"><code class="option">--databases</code></a> option:
      </p><pre class="programlisting copytoclipboard line-numbers language-terminal one-line"><code class="language-terminal">shell&gt; mysqlpump --databases <em class="replaceable">db_name1 db_name2</em> ...</code></pre><p>
        By default, <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> does not dump user
        account definitions, even if you dump the
        <code class="literal">mysql</code> system database that contains the grant
        tables. To dump grant table contents as logical definitions in
        the form of <a class="link" href="create-user.html" title="13.7.1.3 CREATE USER Syntax"><code class="literal">CREATE USER</code></a> and
        <a class="link" href="grant.html" title="13.7.1.6 GRANT Syntax"><code class="literal">GRANT</code></a> statements, use the
        <a class="link" href="mysqlpump.html#option_mysqlpump_users"><code class="option">--users</code></a> option and suppress
        all database dumping:
      </p><pre class="programlisting copytoclipboard line-numbers language-terminal one-line"><code class="language-terminal">shell&gt; mysqlpump --exclude-databases=% --users</code></pre><p>
        In the preceding command, <code class="literal">%</code> is a wildcard
        that matches all database names for the
        <a class="link" href="mysqlpump.html#option_mysqlpump_exclude-databases"><code class="option">--exclude-databases</code></a> option.
      </p><p>
        <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> supports several options for
        including or excluding databases, tables, stored programs, and
        user definitions. See <a class="xref" href="mysqlpump.html#mysqlpump-filtering" title="mysqlpump Object Selection">mysqlpump Object Selection</a>.
      </p><p>
        To reload a dump file, execute the statements that it contains.
        For example, use the <a class="link" href="mysql.html" title="4.5.1 mysql — The MySQL Command-Line Client"><span class="command"><strong>mysql</strong></span></a> client:
      </p><pre class="programlisting copytoclipboard line-numbers language-terminal"><code class="language-terminal">shell&gt; mysqlpump [options] &gt; dump.sql
shell&gt; mysql &lt; dump.sql</code></pre><p>
        The following discussion provides additional
        <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> usage examples.
      </p><p>
        To see a list of the options <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a>
        supports, issue the command <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump --help</strong></span></a>.
</p>
<h4><a name="mysqlpump-option-summary"></a>mysqlpump Option Summary</h4>
<p>
        <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> supports the following options,
        which can be specified on the command line or in the
        <code class="literal">[mysqlpump]</code> and <code class="literal">[client]</code>
        groups of an option file. For information about option files
        used by MySQL programs, see <a class="xref" href="option-files.html" title="4.2.2.2 Using Option Files">Section 4.2.2.2, “Using Option Files”</a>.
</p>
<div class="table">
<a name="idm139663284153376"></a><p class="title"><b>Table 4.15 mysqlpump Options</b></p>
<div class="table-contents">
<table frame="box" rules="all" summary="Command-line options available for mysqlpump."><col width="27%"><col width="50%"><col width="11%"><col width="11%"><thead><tr><th scope="col">Option Name</th>
<th scope="col">Description</th>
<th scope="col">Introduced</th>
<th scope="col">Removed</th>
</tr></thead><tbody><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_add-drop-database">--add-drop-database</a></td>
<td>Add DROP DATABASE statement before each CREATE DATABASE statement</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_add-drop-table">--add-drop-table</a></td>
<td>Add DROP TABLE statement before each CREATE TABLE statement</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_add-drop-user">--add-drop-user</a></td>
<td>Add DROP USER statement before each CREATE USER statement</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_add-locks">--add-locks</a></td>
<td>Surround each table dump with LOCK TABLES and UNLOCK TABLES statements</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_all-databases">--all-databases</a></td>
<td>Dump all databases</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_bind-address">--bind-address</a></td>
<td>Use specified network interface to connect to MySQL Server</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_character-sets-dir">--character-sets-dir</a></td>
<td>Directory where character sets are installed</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_column-statistics">--column-statistics</a></td>
<td>Write ANALYZE TABLE statements to generate statistics histograms</td>
<td>8.0.2</td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_complete-insert">--complete-insert</a></td>
<td>Use complete INSERT statements that include column names</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_compress">--compress</a></td>
<td>Compress all information sent between client and server</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_compress-output">--compress-output</a></td>
<td>Output compression algorithm</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_databases">--databases</a></td>
<td>Interpret all name arguments as database names</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_debug">--debug</a></td>
<td>Write debugging log</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_debug-check">--debug-check</a></td>
<td>Print debugging information when program exits</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_debug-info">--debug-info</a></td>
<td>Print debugging information, memory, and CPU statistics when program exits</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_default-auth">--default-auth</a></td>
<td>Authentication plugin to use</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_default-character-set">--default-character-set</a></td>
<td>Specify default character set</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_default-parallelism">--default-parallelism</a></td>
<td>Default number of threads for parallel processing</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_defaults-extra-file">--defaults-extra-file</a></td>
<td>Read named option file in addition to usual option files</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_defaults-file">--defaults-file</a></td>
<td>Read only named option file</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_defaults-group-suffix">--defaults-group-suffix</a></td>
<td>Option group suffix value</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_defer-table-indexes">--defer-table-indexes</a></td>
<td>For reloading, defer index creation until after loading table rows</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_events">--events</a></td>
<td>Dump events from dumped databases</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_exclude-databases">--exclude-databases</a></td>
<td>Databases to exclude from dump</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_exclude-events">--exclude-events</a></td>
<td>Events to exclude from dump</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_exclude-routines">--exclude-routines</a></td>
<td>Routines to exclude from dump</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_exclude-tables">--exclude-tables</a></td>
<td>Tables to exclude from dump</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_exclude-triggers">--exclude-triggers</a></td>
<td>Triggers to exclude from dump</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_exclude-users">--exclude-users</a></td>
<td>Users to exclude from dump</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_extended-insert">--extended-insert</a></td>
<td>Use multiple-row INSERT syntax</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_get-server-public-key">--get-server-public-key</a></td>
<td>Request RSA public key from server</td>
<td>8.0.3</td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_help">--help</a></td>
<td>Display help message and exit</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_hex-blob">--hex-blob</a></td>
<td>Dump binary columns using hexadecimal notation</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_host">--host</a></td>
<td>Host to connect to (IP address or hostname)</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_include-databases">--include-databases</a></td>
<td>Databases to include in dump</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_include-events">--include-events</a></td>
<td>Events to include in dump</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_include-routines">--include-routines</a></td>
<td>Routines to include in dump</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_include-tables">--include-tables</a></td>
<td>Tables to include in dump</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_include-triggers">--include-triggers</a></td>
<td>Triggers to include in dump</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_include-users">--include-users</a></td>
<td>Users to include in dump</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_insert-ignore">--insert-ignore</a></td>
<td>Write INSERT IGNORE rather than INSERT statements</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_log-error-file">--log-error-file</a></td>
<td>Append warnings and errors to named file</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_login-path">--login-path</a></td>
<td>Read login path options from .mylogin.cnf</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_max-allowed-packet">--max-allowed-packet</a></td>
<td>Maximum packet length to send to or receive from server</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_net-buffer-length">--net-buffer-length</a></td>
<td>Buffer size for TCP/IP and socket communication</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_no-create-db">--no-create-db</a></td>
<td>Do not write CREATE DATABASE statements</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_no-create-info">--no-create-info</a></td>
<td>Do not write CREATE TABLE statements that re-create each dumped table</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_no-defaults">--no-defaults</a></td>
<td>Read no option files</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_parallel-schemas">--parallel-schemas</a></td>
<td>Specify schema-processing parallelism</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_password">--password</a></td>
<td>Password to use when connecting to server</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_plugin-dir">--plugin-dir</a></td>
<td>Directory where plugins are installed</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_port">--port</a></td>
<td>TCP/IP port number for connection</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_print-defaults">--print-defaults</a></td>
<td>Print default options</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_protocol">--protocol</a></td>
<td>Connection protocol to use</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_replace">--replace</a></td>
<td>Write REPLACE statements rather than INSERT statements</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_result-file">--result-file</a></td>
<td>Direct output to a given file</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_routines">--routines</a></td>
<td>Dump stored routines (procedures and functions) from dumped databases</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_secure-auth">--secure-auth</a></td>
<td>Do not send passwords to server in old (pre-4.1) format</td>
<td></td>
<td>8.0.3</td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_server-public-key-path">--server-public-key-path</a></td>
<td>Path name to file containing RSA public key</td>
<td>8.0.4</td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_set-charset">--set-charset</a></td>
<td>Add SET NAMES default_character_set to output</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_set-gtid-purged">--set-gtid-purged</a></td>
<td>Whether to add SET @@GLOBAL.GTID_PURGED to output</td>
<td>8.0.1</td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_single-transaction">--single-transaction</a></td>
<td>Dump tables within single transaction</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_skip-definer">--skip-definer</a></td>
<td>Omit DEFINER and SQL SECURITY clauses from view and stored program CREATE statements</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_skip-dump-rows">--skip-dump-rows</a></td>
<td>Do not dump table rows</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_socket">--socket</a></td>
<td>The Unix socket file or Windows named pipe to use</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_ssl">--ssl-ca</a></td>
<td>File that contains list of trusted SSL Certificate Authorities</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_ssl">--ssl-capath</a></td>
<td>Directory that contains trusted SSL Certificate Authority certificate files</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_ssl">--ssl-cert</a></td>
<td>File that contains X.509 certificate</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_ssl">--ssl-cipher</a></td>
<td>Permissible ciphers for connection encryption</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_ssl">--ssl-crl</a></td>
<td>File that contains certificate revocation lists</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_ssl">--ssl-crlpath</a></td>
<td>Directory that contains certificate revocation-list files</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_ssl-fips-mode">--ssl-fips-mode</a></td>
<td>Whether to enable FIPS mode on client side</td>
<td>8.0.11</td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_ssl">--ssl-key</a></td>
<td>File that contains X.509 key</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_ssl">--ssl-mode</a></td>
<td>Desired security state of connection to server</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_tls-ciphersuites">--tls-ciphersuites</a></td>
<td>Permissible TLSv1.3 ciphersuites for encrypted connections</td>
<td>8.0.16</td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_tls-version">--tls-version</a></td>
<td>Permissible TLS protocols for encrypted connections</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_triggers">--triggers</a></td>
<td>Dump triggers for each dumped table</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_tz-utc">--tz-utc</a></td>
<td>Add SET TIME_ZONE='+00:00' to dump file</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_user">--user</a></td>
<td>MySQL user name to use when connecting to server</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_users">--users</a></td>
<td>Dump user accounts</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_version">--version</a></td>
<td>Display version information and exit</td>
<td></td>
<td></td>
</tr><tr><td scope="row"><a class="link" href="mysqlpump.html#option_mysqlpump_watch-progress">--watch-progress</a></td>
<td>Display progress indicator</td>
<td></td>
<td></td>
</tr></tbody></table>
</div>

</div>
<br class="table-break">
<h4><a name="mysqlpump-options"></a>mysqlpump Option Descriptions</h4>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><a name="option_mysqlpump_help"></a>
            <a class="indexterm" name="idm139663283775792"></a>

            <a class="indexterm" name="idm139663283774336"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_help"><code class="option">--help</code></a>,
            <code class="option">-?</code>
          </p><p>
            Display a help message and exit.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_add-drop-database"></a>
            <a class="indexterm" name="idm139663283769824"></a>

            <a class="indexterm" name="idm139663283768368"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_add-drop-database"><code class="option">--add-drop-database</code></a>
          </p><p>
            Write a <a class="link" href="drop-database.html" title="13.1.24 DROP DATABASE Syntax"><code class="literal">DROP DATABASE</code></a>
            statement before each <a class="link" href="create-database.html" title="13.1.12 CREATE DATABASE Syntax"><code class="literal">CREATE
            DATABASE</code></a> statement.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_add-drop-table"></a>
            <a class="indexterm" name="idm139663283761776"></a>

            <a class="indexterm" name="idm139663283760288"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_add-drop-table"><code class="option">--add-drop-table</code></a>
          </p><p>
            Write a <a class="link" href="drop-table.html" title="13.1.32 DROP TABLE Syntax"><code class="literal">DROP TABLE</code></a> statement
            before each <a class="link" href="create-table.html" title="13.1.20 CREATE TABLE Syntax"><code class="literal">CREATE TABLE</code></a>
            statement.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_add-drop-user"></a>
            <a class="indexterm" name="idm139663283753696"></a>

            <a class="indexterm" name="idm139663283752208"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_add-drop-user"><code class="option">--add-drop-user</code></a>
          </p><p>
            Write a <a class="link" href="drop-user.html" title="13.7.1.5 DROP USER Syntax"><code class="literal">DROP USER</code></a> statement
            before each <a class="link" href="create-user.html" title="13.7.1.3 CREATE USER Syntax"><code class="literal">CREATE USER</code></a>
            statement.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_add-locks"></a>
            <a class="indexterm" name="idm139663283745680"></a>

            <a class="indexterm" name="idm139663283744192"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_add-locks"><code class="option">--add-locks</code></a>
          </p><p>
            Surround each table dump with <a class="link" href="lock-tables.html" title="13.3.6 LOCK TABLES and UNLOCK TABLES Syntax"><code class="literal">LOCK
            TABLES</code></a> and
            <a class="link" href="lock-tables.html" title="13.3.6 LOCK TABLES and UNLOCK TABLES Syntax"><code class="literal">UNLOCK
            TABLES</code></a> statements. This results in faster inserts
            when the dump file is reloaded. See
            <a class="xref" href="insert-optimization.html" title="8.2.5.1 Optimizing INSERT Statements">Section 8.2.5.1, “Optimizing INSERT Statements”</a>.
          </p><p>
            This option does not work with parallelism because
            <a class="link" href="insert.html" title="13.2.6 INSERT Syntax"><code class="literal">INSERT</code></a> statements from
            different tables can be interleaved and
            <a class="link" href="lock-tables.html" title="13.3.6 LOCK TABLES and UNLOCK TABLES Syntax"><code class="literal">UNLOCK
            TABLES</code></a> following the end of the inserts for one
            table could release locks on tables for which inserts
            remain.
          </p><p>
            <a class="link" href="mysqlpump.html#option_mysqlpump_add-locks"><code class="option">--add-locks</code></a> and
            <a class="link" href="mysqlpump.html#option_mysqlpump_single-transaction"><code class="option">--single-transaction</code></a> are
            mutually exclusive.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_all-databases"></a>
            <a class="indexterm" name="idm139663283731328"></a>

            <a class="indexterm" name="idm139663283729840"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_all-databases"><code class="option">--all-databases</code></a>,
            <code class="option">-A</code>
          </p><p>
            Dump all databases (with certain exceptions noted in
            <a class="xref" href="mysqlpump.html#mysqlpump-restrictions" title="mysqlpump Restrictions">mysqlpump Restrictions</a>). This is the
            default behavior if no other is specified explicitly.
          </p><p>
            <a class="link" href="mysqlpump.html#option_mysqlpump_all-databases"><code class="option">--all-databases</code></a> and
            <a class="link" href="mysqlpump.html#option_mysqlpump_databases"><code class="option">--databases</code></a> are mutually
            exclusive.
          </p><p>
            Prior to MySQL 8.0, the
            <a class="link" href="mysqldump.html#option_mysqldump_routines"><code class="option">--routines</code></a> and
            <a class="link" href="mysqldump.html#option_mysqldump_events"><code class="option">--events</code></a> options for
            <a class="link" href="mysqldump.html" title="4.5.4 mysqldump — A Database Backup Program"><span class="command"><strong>mysqldump</strong></span></a> and
            <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> were not required to include
            stored routines and events when using the
            <a class="link" href="mysqldump.html#option_mysqldump_all-databases"><code class="option">--all-databases</code></a> option:
            The dump included the <code class="literal">mysql</code> system
            database, and therefore also the
            <code class="literal">mysql.proc</code> and
            <code class="literal">mysql.event</code> tables containing stored
            routine and event definitions. As of MySQL 8.0,
            the <code class="literal">mysql.event</code> and
            <code class="literal">mysql.proc</code> tables are not used.
            Definitions for the corresponding objects are stored in data
            dictionary tables, but those tables are not dumped. To
            include stored routines and events in a dump made using
            <a class="link" href="mysqldump.html#option_mysqldump_all-databases"><code class="option">--all-databases</code></a>, use the
            <a class="link" href="mysqldump.html#option_mysqldump_routines"><code class="option">--routines</code></a> and
            <a class="link" href="mysqldump.html#option_mysqldump_events"><code class="option">--events</code></a> options
            explicitly.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_bind-address"></a>
            <a class="indexterm" name="idm139663283709264"></a>

            <a class="indexterm" name="idm139663283707808"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_bind-address"><code class="option">--bind-address=<em class="replaceable"><code>ip_address</code></em></code></a>
          </p><p>
            On a computer having multiple network interfaces, use this
            option to select which interface to use for connecting to
            the MySQL server.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_character-sets-dir"></a>
            <a class="indexterm" name="idm139663283703280"></a>

            <a class="indexterm" name="idm139663283701824"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_character-sets-dir"><code class="option">--character-sets-dir=<em class="replaceable"><code>path</code></em></code></a>
          </p><p>
            The directory where character sets are installed. See
            <a class="xref" href="charset-configuration.html" title="10.14 Character Set Configuration">Section 10.14, “Character Set Configuration”</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_column-statistics"></a>
            <a class="link" href="mysqlpump.html#option_mysqlpump_column-statistics"><code class="option">--column-statistics</code></a>
          </p><a class="indexterm" name="idm139663283695552"></a><a class="indexterm" name="idm139663283694096"></a><p>
            Add <a class="link" href="analyze-table.html" title="13.7.3.1 ANALYZE TABLE Syntax"><code class="literal">ANALYZE TABLE</code></a> statements
            to the output to generate histogram statistics for dumped
            tables when the dump file is reloaded. This option is
            disabled by default because histogram generation for large
            tables can take a long time.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_complete-insert"></a>
            <a class="indexterm" name="idm139663283689536"></a>

            <a class="indexterm" name="idm139663283688048"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_complete-insert"><code class="option">--complete-insert</code></a>
          </p><p>
            Write complete <a class="link" href="insert.html" title="13.2.6 INSERT Syntax"><code class="literal">INSERT</code></a>
            statements that include column names.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_compress"></a>
            <a class="indexterm" name="idm139663283682656"></a>

            <a class="indexterm" name="idm139663283681168"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_compress"><code class="option">--compress</code></a>,
            <code class="option">-C</code>
          </p><p>
            Compress all information sent between the client and the
            server if possible. See
            <a class="xref" href="connection-compression-control.html" title="4.2.6 Connection Compression Control">Section 4.2.6, “Connection Compression Control”</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_compress-output"></a>
            <a class="indexterm" name="idm139663283675920"></a>

            <a class="indexterm" name="idm139663283674432"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_compress-output"><code class="option">--compress-output=<em class="replaceable"><code>algorithm</code></em></code></a>
          </p><p>
            By default, <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> does not compress
            output. This option specifies output compression using the
            specified algorithm. Permitted algorithms are
            <code class="literal">LZ4</code> and <code class="literal">ZLIB</code>.
          </p><p>
            To uncompress compressed output, you must have an
            appropriate utility. If the system commands
            <span class="command"><strong>lz4</strong></span> and <span class="command"><strong>openssl zlib</strong></span>
            are not available, MySQL distributions include
            <a class="link" href="lz4-decompress.html" title="4.8.1 lz4_decompress — Decompress mysqlpump LZ4-Compressed Output"><span class="command"><strong>lz4_decompress</strong></span></a> and
            <a class="link" href="zlib-decompress.html" title="4.8.3 zlib_decompress — Decompress mysqlpump ZLIB-Compressed Output"><span class="command"><strong>zlib_decompress</strong></span></a> utilities that can be
            used to decompress <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> output that
            was compressed using the
            <a class="link" href="mysqlpump.html#option_mysqlpump_compress-output"><code class="option">--compress-output=LZ4</code></a> and
            <a class="link" href="mysqlpump.html#option_mysqlpump_compress-output"><code class="option">--compress-output=ZLIB</code></a>
            options. For more information, see
            <a class="xref" href="lz4-decompress.html" title="4.8.1 lz4_decompress — Decompress mysqlpump LZ4-Compressed Output">Section 4.8.1, “<span class="command"><strong>lz4_decompress</strong></span> — Decompress mysqlpump LZ4-Compressed Output”</a>, and
            <a class="xref" href="zlib-decompress.html" title="4.8.3 zlib_decompress — Decompress mysqlpump ZLIB-Compressed Output">Section 4.8.3, “<span class="command"><strong>zlib_decompress</strong></span> — Decompress mysqlpump ZLIB-Compressed Output”</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_databases"></a>
            <a class="indexterm" name="idm139663283658112"></a>

            <a class="indexterm" name="idm139663283656624"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_databases"><code class="option">--databases</code></a>,
            <code class="option">-B</code>
          </p><p>
            Normally, <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> treats the first name
            argument on the command line as a database name and any
            following names as table names. With this option, it treats
            all name arguments as database names.
            <a class="link" href="create-database.html" title="13.1.12 CREATE DATABASE Syntax"><code class="literal">CREATE DATABASE</code></a> statements
            are included in the output before each new database.
          </p><p>
            <a class="link" href="mysqlpump.html#option_mysqlpump_all-databases"><code class="option">--all-databases</code></a> and
            <a class="link" href="mysqlpump.html#option_mysqlpump_databases"><code class="option">--databases</code></a> are mutually
            exclusive.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_debug"></a>
            <a class="indexterm" name="idm139663283646976"></a>

            <a class="indexterm" name="idm139663283645520"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_debug"><code class="option">--debug[=<em class="replaceable"><code>debug_options</code></em>]</code></a>,
            <code class="option">-#
            [<em class="replaceable"><code>debug_options</code></em>]</code>
          </p><p>
            Write a debugging log. A typical
            <em class="replaceable"><code>debug_options</code></em> string is
            <code class="literal">d:t:o,<em class="replaceable"><code>file_name</code></em></code>.
            The default is
            <code class="literal">d:t:O,/tmp/mysqlpump.trace</code>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_debug-check"></a>
            <a class="indexterm" name="idm139663283637968"></a>

            <a class="indexterm" name="idm139663283636480"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_debug-check"><code class="option">--debug-check</code></a>
          </p><p>
            Print some debugging information when the program exits.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_debug-info"></a>
            <a class="indexterm" name="idm139663283632384"></a>

            <a class="indexterm" name="idm139663283630896"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_debug-info"><code class="option">--debug-info</code></a>,
            <code class="option">-T</code>
          </p><p>
            Print debugging information and memory and CPU usage
            statistics when the program exits.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_default-auth"></a>
            <a class="indexterm" name="idm139663283626336"></a>

            <a class="indexterm" name="idm139663283624848"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_default-auth"><code class="option">--default-auth=<em class="replaceable"><code>plugin</code></em></code></a>
          </p><p>
            A hint about which client-side authentication plugin to use.
            See <a class="xref" href="pluggable-authentication.html" title="6.2.17 Pluggable Authentication">Section 6.2.17, “Pluggable Authentication”</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_default-character-set"></a>
            <a class="indexterm" name="idm139663283619744"></a>

            <a class="indexterm" name="idm139663283618288"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_default-character-set"><code class="option">--default-character-set=<em class="replaceable"><code>charset_name</code></em></code></a>
          </p><p>
            Use <em class="replaceable"><code>charset_name</code></em> as the default
            character set. See <a class="xref" href="charset-configuration.html" title="10.14 Character Set Configuration">Section 10.14, “Character Set Configuration”</a>.
            If no character set is specified,
            <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> uses <code class="literal">utf8</code>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_default-parallelism"></a>
            <a class="indexterm" name="idm139663283610736"></a>

            <a class="indexterm" name="idm139663283609280"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_default-parallelism"><code class="option">--default-parallelism=<em class="replaceable"><code>N</code></em></code></a>
          </p><p>
            The default number of threads for each parallel processing
            queue. The default is 2.
          </p><p>
            The <a class="link" href="mysqlpump.html#option_mysqlpump_parallel-schemas"><code class="option">--parallel-schemas</code></a>
            option also affects parallelism and can be used to override
            the default number of threads. For more information, see
            <a class="xref" href="mysqlpump.html#mysqlpump-parallelism" title="mysqlpump Parallel Processing">mysqlpump Parallel Processing</a>.
          </p><p>
            With
            <a class="link" href="mysqlpump.html#option_mysqlpump_default-parallelism"><code class="option">--default-parallelism=0</code></a>
            and no <a class="link" href="mysqlpump.html#option_mysqlpump_parallel-schemas"><code class="option">--parallel-schemas</code></a>
            options, <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> runs as a
            single-threaded process and creates no queues.
          </p><p>
            With parallelism enabled, it is possible for output from
            different databases to be interleaved.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_defaults-extra-file"></a>
            <a class="indexterm" name="idm139663283598304"></a>

            <a class="indexterm" name="idm139663283596848"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_defaults-extra-file"><code class="option">--defaults-extra-file=<em class="replaceable"><code>file_name</code></em></code></a>
          </p><p>
            Read this option file after the global option file but (on
            Unix) before the user option file. If the file does not
            exist or is otherwise inaccessible, an error occurs.
            <em class="replaceable"><code>file_name</code></em> is interpreted relative
            to the current directory if given as a relative path name
            rather than a full path name.
          </p><p>
            For additional information about this and other option-file
            options, see <a class="xref" href="option-file-options.html" title="4.2.2.3 Command-Line Options that Affect Option-File Handling">Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling”</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_defaults-file"></a>
            <a class="indexterm" name="idm139663283590512"></a>

            <a class="indexterm" name="idm139663283589024"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_defaults-file"><code class="option">--defaults-file=<em class="replaceable"><code>file_name</code></em></code></a>
          </p><p>
            Use only the given option file. If the file does not exist
            or is otherwise inaccessible, an error occurs.
            <em class="replaceable"><code>file_name</code></em> is interpreted relative
            to the current directory if given as a relative path name
            rather than a full path name.
          </p><p>
            Exception: Even with
            <a class="link" href="option-file-options.html#option_general_defaults-file"><code class="option">--defaults-file</code></a>, client
            programs read <code class="filename">.mylogin.cnf</code>.
          </p><p>
            For additional information about this and other option-file
            options, see <a class="xref" href="option-file-options.html" title="4.2.2.3 Command-Line Options that Affect Option-File Handling">Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling”</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_defaults-group-suffix"></a>
            <a class="indexterm" name="idm139663283580592"></a>

            <a class="indexterm" name="idm139663283579136"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_defaults-group-suffix"><code class="option">--defaults-group-suffix=<em class="replaceable"><code>str</code></em></code></a>
          </p><p>
            Read not only the usual option groups, but also groups with
            the usual names and a suffix of
            <em class="replaceable"><code>str</code></em>. For example,
            <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> normally reads the
            <code class="literal">[client]</code> and
            <code class="literal">[mysqlpump]</code> groups. If the
            <a class="link" href="mysqlpump.html#option_mysqlpump_defaults-group-suffix"><code class="option">--defaults-group-suffix=_other</code></a>
            option is given, <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> also reads the
            <code class="literal">[client_other]</code> and
            <code class="literal">[mysqlpump_other]</code> groups.
          </p><p>
            For additional information about this and other option-file
            options, see <a class="xref" href="option-file-options.html" title="4.2.2.3 Command-Line Options that Affect Option-File Handling">Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling”</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_defer-table-indexes"></a>
            <a class="indexterm" name="idm139663283566640"></a>

            <a class="indexterm" name="idm139663283565184"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_defer-table-indexes"><code class="option">--defer-table-indexes</code></a>
          </p><p>
            In the dump output, defer index creation for each table
            until after its rows have been loaded. This works for all
            storage engines, but for <code class="literal">InnoDB</code> applies
            only for secondary indexes.
          </p><p>
            This option is enabled by default; use
            <a class="link" href="mysqlpump.html#option_mysqlpump_defer-table-indexes"><code class="option">--skip-defer-table-indexes</code></a>
            to disable it.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_events"></a>
            <a class="indexterm" name="idm139663283558656"></a>

            <a class="indexterm" name="idm139663283557200"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_events"><code class="option">--events</code></a>
          </p><p>
            Include Event Scheduler events for the dumped databases in
            the output. Event dumping requires the
            <a class="link" href="privileges-provided.html#priv_event"><code class="literal">EVENT</code></a> privileges for those
            databases.
          </p><p>
            The output generated by using
            <a class="link" href="mysqlpump.html#option_mysqlpump_events"><code class="option">--events</code></a> contains
            <a class="link" href="create-event.html" title="13.1.13 CREATE EVENT Syntax"><code class="literal">CREATE EVENT</code></a> statements to
            create the events.
          </p><p>
            This option is enabled by default; use
            <a class="link" href="mysqlpump.html#option_mysqlpump_events"><code class="option">--skip-events</code></a>
            to disable it.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_exclude-databases"></a>
            <a class="indexterm" name="idm139663283547648"></a>

            <a class="indexterm" name="idm139663283546192"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_exclude-databases"><code class="option">--exclude-databases=<em class="replaceable"><code>db_list</code></em></code></a>
          </p><p>
            Do not dump the databases in
            <em class="replaceable"><code>db_list</code></em>, which is a list of one
            or more comma-separated database names. Multiple instances
            of this option are additive. For more information, see
            <a class="xref" href="mysqlpump.html#mysqlpump-filtering" title="mysqlpump Object Selection">mysqlpump Object Selection</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_exclude-events"></a>
            <a class="indexterm" name="idm139663283540432"></a>

            <a class="indexterm" name="idm139663283538944"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_exclude-events"><code class="option">--exclude-events=<em class="replaceable"><code>event_list</code></em></code></a>
          </p><p>
            Do not dump the databases in
            <em class="replaceable"><code>event_list</code></em>, which is a list of
            one or more comma-separated event names. Multiple instances
            of this option are additive. For more information, see
            <a class="xref" href="mysqlpump.html#mysqlpump-filtering" title="mysqlpump Object Selection">mysqlpump Object Selection</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_exclude-routines"></a>
            <a class="indexterm" name="idm139663283533248"></a>

            <a class="indexterm" name="idm139663283531760"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_exclude-routines"><code class="option">--exclude-routines=<em class="replaceable"><code>routine_list</code></em></code></a>
          </p><p>
            Do not dump the events in
            <em class="replaceable"><code>routine_list</code></em>, which is a list of
            one or more comma-separated routine (stored procedure or
            function) names. Multiple instances of this option are
            additive. For more information, see
            <a class="xref" href="mysqlpump.html#mysqlpump-filtering" title="mysqlpump Object Selection">mysqlpump Object Selection</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_exclude-tables"></a>
            <a class="indexterm" name="idm139663283526080"></a>

            <a class="indexterm" name="idm139663283524592"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_exclude-tables"><code class="option">--exclude-tables=<em class="replaceable"><code>table_list</code></em></code></a>
          </p><p>
            Do not dump the tables in
            <em class="replaceable"><code>table_list</code></em>, which is a list of
            one or more comma-separated table names. Multiple instances
            of this option are additive. For more information, see
            <a class="xref" href="mysqlpump.html#mysqlpump-filtering" title="mysqlpump Object Selection">mysqlpump Object Selection</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_exclude-triggers"></a>
            <a class="indexterm" name="idm139663283518896"></a>

            <a class="indexterm" name="idm139663283517408"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_exclude-triggers"><code class="option">--exclude-triggers=<em class="replaceable"><code>trigger_list</code></em></code></a>
          </p><p>
            Do not dump the triggers in
            <em class="replaceable"><code>trigger_list</code></em>, which is a list of
            one or more comma-separated trigger names. Multiple
            instances of this option are additive. For more information,
            see <a class="xref" href="mysqlpump.html#mysqlpump-filtering" title="mysqlpump Object Selection">mysqlpump Object Selection</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_exclude-users"></a>
            <a class="indexterm" name="idm139663283511776"></a>

            <a class="indexterm" name="idm139663283510288"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_exclude-users"><code class="option">--exclude-users=<em class="replaceable"><code>user_list</code></em></code></a>
          </p><p>
            Do not dump the user accounts in
            <em class="replaceable"><code>user_list</code></em>, which is a list of one
            or more comma-separated account names. Multiple instances of
            this option are additive. For more information, see
            <a class="xref" href="mysqlpump.html#mysqlpump-filtering" title="mysqlpump Object Selection">mysqlpump Object Selection</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_extended-insert"></a>
            <a class="indexterm" name="idm139663283504640"></a>

            <a class="indexterm" name="idm139663283503152"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_extended-insert"><code class="option">--extended-insert=<em class="replaceable"><code>N</code></em></code></a>
          </p><p>
            Write <a class="link" href="insert.html" title="13.2.6 INSERT Syntax"><code class="literal">INSERT</code></a> statements using
            multiple-row syntax that includes several
            <code class="literal">VALUES</code> lists. This results in a smaller
            dump file and speeds up inserts when the file is reloaded.
          </p><p>
            The option value indicates the number of rows to include in
            each <a class="link" href="insert.html" title="13.2.6 INSERT Syntax"><code class="literal">INSERT</code></a> statement. The
            default is 250. A value of 1 produces one
            <a class="link" href="insert.html" title="13.2.6 INSERT Syntax"><code class="literal">INSERT</code></a> statement per table
            row.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_get-server-public-key"></a>
            <a class="indexterm" name="idm139663283493696"></a>

            <a class="indexterm" name="idm139663283492240"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_get-server-public-key"><code class="option">--get-server-public-key</code></a>
          </p><p>
            Request from the server the public key required for RSA key
            pair-based password exchange. This option applies to clients
            that authenticate with the
            <code class="literal">caching_sha2_password</code> authentication
            plugin. For that plugin, the server does not send the public
            key unless requested. This option is ignored for accounts
            that do not authenticate with that plugin. It is also
            ignored if RSA-based password exchange is not used, as is
            the case when the client connects to the server using a
            secure connection.
          </p><p>
            If
            <a class="link" href="mysqlpump.html#option_mysqlpump_server-public-key-path"><code class="option">--server-public-key-path=<em class="replaceable"><code>file_name</code></em></code></a>
            is given and specifies a valid public key file, it takes
            precedence over
            <a class="link" href="mysqlpump.html#option_mysqlpump_get-server-public-key"><code class="option">--get-server-public-key</code></a>.
          </p><p>
            For information about the
            <code class="literal">caching_sha2_password</code> plugin, see
            <a class="xref" href="caching-sha2-pluggable-authentication.html" title="6.4.1.3 Caching SHA-2 Pluggable Authentication">Section 6.4.1.3, “Caching SHA-2 Pluggable Authentication”</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_hex-blob"></a>
            <a class="indexterm" name="idm139663283482096"></a>

            <a class="indexterm" name="idm139663283480608"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_hex-blob"><code class="option">--hex-blob</code></a>
          </p><p>
            Dump binary columns using hexadecimal notation (for example,
            <code class="literal">'abc'</code> becomes
            <code class="literal">0x616263</code>). The affected data types are
            <a class="link" href="binary-varbinary.html" title="11.4.2 The BINARY and VARBINARY Types"><code class="literal">BINARY</code></a>,
            <a class="link" href="binary-varbinary.html" title="11.4.2 The BINARY and VARBINARY Types"><code class="literal">VARBINARY</code></a>, the
            <a class="link" href="blob.html" title="11.4.3 The BLOB and TEXT Types"><code class="literal">BLOB</code></a> types, and
            <a class="link" href="bit-type.html" title="11.2.4 Bit-Value Type - BIT"><code class="literal">BIT</code></a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_host"></a>
            <a class="indexterm" name="idm139663283470112"></a>

            <a class="indexterm" name="idm139663283468656"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_host"><code class="option">--host=<em class="replaceable"><code>host_name</code></em></code></a>,
            <code class="option">-h <em class="replaceable"><code>host_name</code></em></code>
          </p><p>
            Dump data from the MySQL server on the given host.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_include-databases"></a>
            <a class="indexterm" name="idm139663283463552"></a>

            <a class="indexterm" name="idm139663283462096"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_include-databases"><code class="option">--include-databases=<em class="replaceable"><code>db_list</code></em></code></a>
          </p><p>
            Dump the databases in <em class="replaceable"><code>db_list</code></em>,
            which is a list of one or more comma-separated database
            names. The dump includes all objects in the named databases.
            Multiple instances of this option are additive. For more
            information, see <a class="xref" href="mysqlpump.html#mysqlpump-filtering" title="mysqlpump Object Selection">mysqlpump Object Selection</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_include-events"></a>
            <a class="indexterm" name="idm139663283456288"></a>

            <a class="indexterm" name="idm139663283454800"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_include-events"><code class="option">--include-events=<em class="replaceable"><code>event_list</code></em></code></a>
          </p><p>
            Dump the events in <em class="replaceable"><code>event_list</code></em>,
            which is a list of one or more comma-separated event names.
            Multiple instances of this option are additive. For more
            information, see <a class="xref" href="mysqlpump.html#mysqlpump-filtering" title="mysqlpump Object Selection">mysqlpump Object Selection</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_include-routines"></a>
            <a class="indexterm" name="idm139663283449184"></a>

            <a class="indexterm" name="idm139663283447696"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_include-routines"><code class="option">--include-routines=<em class="replaceable"><code>routine_list</code></em></code></a>
          </p><p>
            Dump the routines in
            <em class="replaceable"><code>routine_list</code></em>, which is a list of
            one or more comma-separated routine (stored procedure or
            function) names. Multiple instances of this option are
            additive. For more information, see
            <a class="xref" href="mysqlpump.html#mysqlpump-filtering" title="mysqlpump Object Selection">mysqlpump Object Selection</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_include-tables"></a>
            <a class="indexterm" name="idm139663283442016"></a>

            <a class="indexterm" name="idm139663283440528"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_include-tables"><code class="option">--include-tables=<em class="replaceable"><code>table_list</code></em></code></a>
          </p><p>
            Dump the tables in <em class="replaceable"><code>table_list</code></em>,
            which is a list of one or more comma-separated table names.
            Multiple instances of this option are additive. For more
            information, see <a class="xref" href="mysqlpump.html#mysqlpump-filtering" title="mysqlpump Object Selection">mysqlpump Object Selection</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_include-triggers"></a>
            <a class="indexterm" name="idm139663283434912"></a>

            <a class="indexterm" name="idm139663283433424"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_include-triggers"><code class="option">--include-triggers=<em class="replaceable"><code>trigger_list</code></em></code></a>
          </p><p>
            Dump the triggers in
            <em class="replaceable"><code>trigger_list</code></em>, which is a list of
            one or more comma-separated trigger names. Multiple
            instances of this option are additive. For more information,
            see <a class="xref" href="mysqlpump.html#mysqlpump-filtering" title="mysqlpump Object Selection">mysqlpump Object Selection</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_include-users"></a>
            <a class="indexterm" name="idm139663283427792"></a>

            <a class="indexterm" name="idm139663283426304"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_include-users"><code class="option">--include-users=<em class="replaceable"><code>user_list</code></em></code></a>
          </p><p>
            Dump the user accounts in
            <em class="replaceable"><code>user_list</code></em>, which is a list of one
            or more comma-separated user names. Multiple instances of
            this option are additive. For more information, see
            <a class="xref" href="mysqlpump.html#mysqlpump-filtering" title="mysqlpump Object Selection">mysqlpump Object Selection</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_insert-ignore"></a>
            <a class="indexterm" name="idm139663283420608"></a>

            <a class="indexterm" name="idm139663283419120"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_insert-ignore"><code class="option">--insert-ignore</code></a>
          </p><p>
            Write <a class="link" href="insert.html" title="13.2.6 INSERT Syntax"><code class="literal">INSERT
            IGNORE</code></a> statements rather than
            <a class="link" href="insert.html" title="13.2.6 INSERT Syntax"><code class="literal">INSERT</code></a> statements.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_log-error-file"></a>
            <a class="indexterm" name="idm139663283412528"></a>

            <a class="indexterm" name="idm139663283411040"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_log-error-file"><code class="option">--log-error-file=<em class="replaceable"><code>file_name</code></em></code></a>
          </p><p>
            Log warnings and errors by appending them to the named file.
            If this option is not given, <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a>
            writes warnings and errors to the standard error output.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_login-path"></a>
            <a class="indexterm" name="idm139663283405328"></a>

            <a class="indexterm" name="idm139663283403840"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_login-path"><code class="option">--login-path=<em class="replaceable"><code>name</code></em></code></a>
          </p><p>
            Read options from the named login path in the
            <code class="filename">.mylogin.cnf</code> login path file. A
            <span class="quote">“<span class="quote">login path</span>”</span> is an option group containing
            options that specify which MySQL server to connect to and
            which account to authenticate as. To create or modify a
            login path file, use the
            <a class="link" href="mysql-config-editor.html" title="4.6.7 mysql_config_editor — MySQL Configuration Utility"><span class="command"><strong>mysql_config_editor</strong></span></a> utility. See
            <a class="xref" href="mysql-config-editor.html" title="4.6.7 mysql_config_editor — MySQL Configuration Utility">Section 4.6.7, “<span class="command"><strong>mysql_config_editor</strong></span> — MySQL Configuration Utility”</a>.
          </p><p>
            For additional information about this and other option-file
            options, see <a class="xref" href="option-file-options.html" title="4.2.2.3 Command-Line Options that Affect Option-File Handling">Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling”</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_max-allowed-packet"></a>
            <a class="indexterm" name="idm139663283394928"></a>

            <a class="indexterm" name="idm139663283393472"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_max-allowed-packet"><code class="option">--max-allowed-packet=<em class="replaceable"><code>N</code></em></code></a>
          </p><p>
            The maximum size of the buffer for client/server
            communication. The default is 24MB, the maximum is 1GB.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_net-buffer-length"></a>
            <a class="indexterm" name="idm139663283388992"></a>

            <a class="indexterm" name="idm139663283387536"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_net-buffer-length"><code class="option">--net-buffer-length=<em class="replaceable"><code>N</code></em></code></a>
          </p><p>
            The initial size of the buffer for client/server
            communication. When creating multiple-row
            <a class="link" href="insert.html" title="13.2.6 INSERT Syntax"><code class="literal">INSERT</code></a> statements (as with
            the <a class="link" href="mysqlpump.html#option_mysqlpump_extended-insert"><code class="option">--extended-insert</code></a>
            option), <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> creates rows up to
            <em class="replaceable"><code>N</code></em> bytes long. If you use this
            option to increase the value, ensure that the MySQL server
            <a class="link" href="server-system-variables.html#sysvar_net_buffer_length"><code class="literal">net_buffer_length</code></a> system
            variable has a value at least this large.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_no-create-db"></a>
            <a class="indexterm" name="idm139663283377680"></a>

            <a class="indexterm" name="idm139663283376192"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_no-create-db"><code class="option">--no-create-db</code></a>
          </p><p>
            Suppress any <a class="link" href="create-database.html" title="13.1.12 CREATE DATABASE Syntax"><code class="literal">CREATE DATABASE</code></a>
            statements that might otherwise be included in the output.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_no-create-info"></a>
            <a class="indexterm" name="idm139663283370848"></a>

            <a class="indexterm" name="idm139663283369360"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_no-create-info"><code class="option">--no-create-info</code></a>,
            <code class="option">-t</code>
          </p><p>
            Do not write <a class="link" href="create-table.html" title="13.1.20 CREATE TABLE Syntax"><code class="literal">CREATE TABLE</code></a>
            statements that create each dumped table.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_no-defaults"></a>
            <a class="indexterm" name="idm139663283363616"></a>

            <a class="indexterm" name="idm139663283362128"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_no-defaults"><code class="option">--no-defaults</code></a>
          </p><p>
            Do not read any option files. If program startup fails due
            to reading unknown options from an option file,
            <a class="link" href="mysqlpump.html#option_mysqlpump_no-defaults"><code class="option">--no-defaults</code></a> can be used
            to prevent them from being read.
          </p><p>
            The exception is that the <code class="filename">.mylogin.cnf</code>
            file, if it exists, is read in all cases. This permits
            passwords to be specified in a safer way than on the command
            line even when
            <a class="link" href="mysqlpump.html#option_mysqlpump_no-defaults"><code class="option">--no-defaults</code></a> is used.
            (<code class="filename">.mylogin.cnf</code> is created by the
            <a class="link" href="mysql-config-editor.html" title="4.6.7 mysql_config_editor — MySQL Configuration Utility"><span class="command"><strong>mysql_config_editor</strong></span></a> utility. See
            <a class="xref" href="mysql-config-editor.html" title="4.6.7 mysql_config_editor — MySQL Configuration Utility">Section 4.6.7, “<span class="command"><strong>mysql_config_editor</strong></span> — MySQL Configuration Utility”</a>.)
          </p><p>
            For additional information about this and other option-file
            options, see <a class="xref" href="option-file-options.html" title="4.2.2.3 Command-Line Options that Affect Option-File Handling">Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling”</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_parallel-schemas"></a>
            <a class="indexterm" name="idm139663283350800"></a>

            <a class="indexterm" name="idm139663283349312"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_parallel-schemas"><code class="option">--parallel-schemas=[<em class="replaceable"><code>N</code></em>:]<em class="replaceable"><code>db_list</code></em></code></a>
          </p><p>
            Create a queue for processing the databases in
            <em class="replaceable"><code>db_list</code></em>, which is a list of one
            or more comma-separated database names. If
            <em class="replaceable"><code>N</code></em> is given, the queue uses
            <em class="replaceable"><code>N</code></em> threads. If
            <em class="replaceable"><code>N</code></em> is not given, the
            <a class="link" href="mysqlpump.html#option_mysqlpump_default-parallelism"><code class="option">--default-parallelism</code></a>
            option determines the number of queue threads.
          </p><p>
            Multiple instances of this option create multiple queues.
            <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> also creates a default queue to
            use for databases not named in any
            <a class="link" href="mysqlpump.html#option_mysqlpump_parallel-schemas"><code class="option">--parallel-schemas</code></a> option,
            and for dumping user definitions if command options select
            them. For more information, see
            <a class="xref" href="mysqlpump.html#mysqlpump-parallelism" title="mysqlpump Parallel Processing">mysqlpump Parallel Processing</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_password"></a>
            <a class="indexterm" name="idm139663283338032"></a>

            <a class="indexterm" name="idm139663283336544"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_password"><code class="option">--password[=<em class="replaceable"><code>password</code></em>]</code></a>,
            <code class="option">-p[<em class="replaceable"><code>password</code></em>]</code>
          </p><p>
            The password of the MySQL account used for connecting to the
            server. The password value is optional. If not given,
            <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> prompts for one. If given,
            there must be <span class="emphasis"><em>no space</em></span> between
            <a class="link" href="mysqlpump.html#option_mysqlpump_password"><code class="option">--password=</code></a> or
            <code class="option">-p</code> and the password following it. If no
            password option is specified, the default is to send no
            password.
          </p><p>
            Specifying a password on the command line should be
            considered insecure. To avoid giving the password on the
            command line, use an option file. See
            <a class="xref" href="password-security-user.html" title="6.1.2.1 End-User Guidelines for Password Security">Section 6.1.2.1, “End-User Guidelines for Password Security”</a>.
          </p><p>
            To explicitly specify that there is no password and that
            <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> should not prompt for one, use
            the
            <a class="link" href="mysqlpump.html#option_mysqlpump_password"><code class="option">--skip-password</code></a>
            option.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_plugin-dir"></a>
            <a class="indexterm" name="idm139663283323776"></a>

            <a class="indexterm" name="idm139663283322288"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_plugin-dir"><code class="option">--plugin-dir=<em class="replaceable"><code>dir_name</code></em></code></a>
          </p><p>
            The directory in which to look for plugins. Specify this
            option if the
            <a class="link" href="mysqlpump.html#option_mysqlpump_default-auth"><code class="option">--default-auth</code></a> option is
            used to specify an authentication plugin but
            <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> does not find it. See
            <a class="xref" href="pluggable-authentication.html" title="6.2.17 Pluggable Authentication">Section 6.2.17, “Pluggable Authentication”</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_port"></a>
            <a class="indexterm" name="idm139663283314800"></a>

            <a class="indexterm" name="idm139663283313344"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_port"><code class="option">--port=<em class="replaceable"><code>port_num</code></em></code></a>,
            <code class="option">-P <em class="replaceable"><code>port_num</code></em></code>
          </p><p>
            For TCP/IP connections, the port number to use.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_print-defaults"></a>
            <a class="indexterm" name="idm139663283308240"></a>

            <a class="indexterm" name="idm139663283306752"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_print-defaults"><code class="option">--print-defaults</code></a>
          </p><p>
            Print the program name and all options that it gets from
            option files.
          </p><p>
            For additional information about this and other option-file
            options, see <a class="xref" href="option-file-options.html" title="4.2.2.3 Command-Line Options that Affect Option-File Handling">Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling”</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_protocol"></a>
            <a class="indexterm" name="idm139663283301456"></a>

            <a class="indexterm" name="idm139663283299968"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_protocol"><code class="option">--protocol={TCP|SOCKET|PIPE|MEMORY}</code></a>
          </p><p>
            The connection protocol to use for connecting to the server.
            It is useful when the other connection parameters normally
            result in use of a protocol other than the one you want. For
            details on the permissible values, see
            <a class="xref" href="connecting.html" title="4.2.4 Connecting to the MySQL Server Using Command Options">Section 4.2.4, “Connecting to the MySQL Server Using Command Options”</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_replace"></a>
            <a class="indexterm" name="idm139663283294912"></a>

            <a class="indexterm" name="idm139663283293424"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_replace"><code class="option">--replace</code></a>
          </p><p>
            Write <a class="link" href="replace.html" title="13.2.9 REPLACE Syntax"><code class="literal">REPLACE</code></a> statements
            rather than <a class="link" href="insert.html" title="13.2.6 INSERT Syntax"><code class="literal">INSERT</code></a>
            statements.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_result-file"></a>
            <a class="indexterm" name="idm139663283286832"></a>

            <a class="indexterm" name="idm139663283285344"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_result-file"><code class="option">--result-file=<em class="replaceable"><code>file_name</code></em></code></a>
          </p><p>
            Direct output to the named file. The result file is created
            and its previous contents overwritten, even if an error
            occurs while generating the dump.
          </p><p>
            This option should be used on Windows to prevent newline
            <code class="literal">\n</code> characters from being converted to
            <code class="literal">\r\n</code> carriage return/newline sequences.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_routines"></a>
            <a class="indexterm" name="idm139663283278832"></a>

            <a class="indexterm" name="idm139663283277344"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_routines"><code class="option">--routines</code></a>
          </p><p>
            Include stored routines (procedures and functions) for the
            dumped databases in the output. This option requires the
            global <a class="link" href="privileges-provided.html#priv_select"><code class="literal">SELECT</code></a> privilege.
          </p><p>
            The output generated by using
            <a class="link" href="mysqlpump.html#option_mysqlpump_routines"><code class="option">--routines</code></a> contains
            <a class="link" href="create-procedure.html" title="13.1.17 CREATE PROCEDURE and CREATE FUNCTION Syntax"><code class="literal">CREATE PROCEDURE</code></a> and
            <a class="link" href="create-function.html" title="13.1.14 CREATE FUNCTION Syntax"><code class="literal">CREATE FUNCTION</code></a> statements to
            create the routines.
          </p><p>
            This option is enabled by default; use
            <a class="link" href="mysqlpump.html#option_mysqlpump_routines"><code class="option">--skip-routines</code></a>
            to disable it.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_secure-auth"></a>
            <a class="indexterm" name="idm139663283266512"></a>

            <a class="indexterm" name="idm139663283265024"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_secure-auth"><code class="option">--secure-auth</code></a>
          </p><p>
            This option was removed in MySQL 8.0.3.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_server-public-key-path"></a>
            <a class="indexterm" name="idm139663283260944"></a>

            <a class="indexterm" name="idm139663283259488"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_server-public-key-path"><code class="option">--server-public-key-path=<em class="replaceable"><code>file_name</code></em></code></a>
          </p><p>
            The path name to a file containing a client-side copy of the
            public key required by the server for RSA key pair-based
            password exchange. The file must be in PEM format. This
            option applies to clients that authenticate with the
            <code class="literal">sha256_password</code> or
            <code class="literal">caching_sha2_password</code> authentication
            plugin. This option is ignored for accounts that do not
            authenticate with one of those plugins. It is also ignored
            if RSA-based password exchange is not used, as is the case
            when the client connects to the server using a secure
            connection.
          </p><p>
            If
            <a class="link" href="mysqlpump.html#option_mysqlpump_server-public-key-path"><code class="option">--server-public-key-path=<em class="replaceable"><code>file_name</code></em></code></a>
            is given and specifies a valid public key file, it takes
            precedence over
            <a class="link" href="mysqlpump.html#option_mysqlpump_get-server-public-key"><code class="option">--get-server-public-key</code></a>.
          </p><p>
            For <code class="literal">sha256_password</code>, this option applies
            only if MySQL was built using OpenSSL.
          </p><p>
            For information about the <code class="literal">sha256_password</code>
            and <code class="literal">caching_sha2_password</code> plugins, see
            <a class="xref" href="sha256-pluggable-authentication.html" title="6.4.1.2 SHA-256 Pluggable Authentication">Section 6.4.1.2, “SHA-256 Pluggable Authentication”</a>, and
            <a class="xref" href="caching-sha2-pluggable-authentication.html" title="6.4.1.3 Caching SHA-2 Pluggable Authentication">Section 6.4.1.3, “Caching SHA-2 Pluggable Authentication”</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_set-charset"></a>
            <a class="indexterm" name="idm139663283245760"></a>

            <a class="indexterm" name="idm139663283244272"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_set-charset"><code class="option">--set-charset</code></a>
          </p><p>
            Write <a class="link" href="set-names.html" title="13.7.5.3 SET NAMES Syntax"><code class="literal">SET NAMES
            <em class="replaceable"><code>default_character_set</code></em></code></a>
            to the output.
          </p><p>
            This option is enabled by default. To disable it and
            suppress the <a class="link" href="set-names.html" title="13.7.5.3 SET NAMES Syntax"><code class="literal">SET NAMES</code></a>
            statement, use
            <a class="link" href="mysqlpump.html#option_mysqlpump_set-charset"><code class="option">--skip-set-charset</code></a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_set-gtid-purged"></a>
            <a class="indexterm" name="idm139663283235952"></a>

            <a class="indexterm" name="idm139663283234464"></a>

            <code class="option">--set-gtid-purged=<em class="replaceable"><code>value</code></em></code>
          </p><p>
            This option enables control over global transaction ID
            (GTID) information written to the dump file, by indicating
            whether to add a
            <a class="link" href="set-variable.html" title="13.7.5.1 SET Syntax for Variable Assignment"><code class="literal">SET
            @@GLOBAL.gtid_purged</code></a> statement to the output. This
            option may also cause a statement to be written to the
            output that disables binary logging while the dump file is
            being reloaded.
          </p><p>
            The following table shows the permitted option values. The
            default value is <code class="literal">AUTO</code>.
</p>
<div class="informaltable">
<table summary="Permitted option values for the mysqlpump --set-gtid-purged option."><col width="10%"><col width="90%"><thead><tr>
                <th scope="col">Value</th>
                <th scope="col">Meaning</th>
              </tr></thead><tbody><tr>
                <td scope="row"><code class="literal">OFF</code></td>
                <td>Add no <code class="literal">SET</code> statement to the output.</td>
              </tr><tr>
                <td scope="row"><code class="literal">ON</code></td>
                <td>Add a <code class="literal">SET</code> statement to the output. An error occurs if
                  GTIDs are not enabled on the server.</td>
              </tr><tr>
                <td scope="row"><code class="literal">AUTO</code></td>
                <td>Add a <code class="literal">SET</code> statement to the output if GTIDs are
                  enabled on the server.</td>
</tr></tbody></table>
</div>
<p>
            The <code class="option">--set-gtid-purged</code> option has the
            following effect on binary logging when the dump file is
            reloaded:
</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: circle; "><li class="listitem"><p>
                <code class="option">--set-gtid-purged=OFF</code>: <code class="literal">SET
                @@SESSION.SQL_LOG_BIN=0;</code> is not added to the
                output.
              </p></li><li class="listitem"><p>
                <code class="option">--set-gtid-purged=ON</code>: <code class="literal">SET
                @@SESSION.SQL_LOG_BIN=0;</code> is added to the
                output.
              </p></li><li class="listitem"><p>
                <code class="option">--set-gtid-purged=AUTO</code>: <code class="literal">SET
                @@SESSION.SQL_LOG_BIN=0;</code> is added to the
                output if GTIDs are enabled on the server you are
                backing up (that is, if <code class="literal">AUTO</code>
                evaluates to <code class="literal">ON</code>).
</p></li></ul>
</div>
</li><li class="listitem"><p><a name="option_mysqlpump_single-transaction"></a>
            <a class="indexterm" name="idm139663283202832"></a>

            <a class="indexterm" name="idm139663283201376"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_single-transaction"><code class="option">--single-transaction</code></a>
          </p><p>
            This option sets the transaction isolation mode to
            <a class="link" href="innodb-transaction-isolation-levels.html#isolevel_repeatable-read"><code class="literal">REPEATABLE READ</code></a> and sends
            a <a class="link" href="commit.html" title="13.3.1 START TRANSACTION, COMMIT, and ROLLBACK Syntax"><code class="literal">START
            TRANSACTION</code></a> SQL statement to the server before
            dumping data. It is useful only with transactional tables
            such as <code class="literal">InnoDB</code>, because then it dumps the
            consistent state of the database at the time when
            <a class="link" href="commit.html" title="13.3.1 START TRANSACTION, COMMIT, and ROLLBACK Syntax"><code class="literal">START
            TRANSACTION</code></a> was issued without blocking any
            applications.
          </p><p>
            When using this option, you should keep in mind that only
            <code class="literal">InnoDB</code> tables are dumped in a consistent
            state. For example, any <code class="literal">MyISAM</code> or
            <code class="literal">MEMORY</code> tables dumped while using this
            option may still change state.
          </p><p>
            While a
            <a class="link" href="mysqlpump.html#option_mysqlpump_single-transaction"><code class="option">--single-transaction</code></a> dump
            is in process, to ensure a valid dump file (correct table
            contents and binary log coordinates), no other connection
            should use the following statements:
            <a class="link" href="alter-table.html" title="13.1.9 ALTER TABLE Syntax"><code class="literal">ALTER TABLE</code></a>,
            <a class="link" href="create-table.html" title="13.1.20 CREATE TABLE Syntax"><code class="literal">CREATE TABLE</code></a>,
            <a class="link" href="drop-table.html" title="13.1.32 DROP TABLE Syntax"><code class="literal">DROP TABLE</code></a>,
            <a class="link" href="rename-table.html" title="13.1.36 RENAME TABLE Syntax"><code class="literal">RENAME TABLE</code></a>,
            <a class="link" href="truncate-table.html" title="13.1.37 TRUNCATE TABLE Syntax"><code class="literal">TRUNCATE TABLE</code></a>. A consistent
            read is not isolated from those statements, so use of them
            on a table to be dumped can cause the
            <a class="link" href="select.html" title="13.2.10 SELECT Syntax"><code class="literal">SELECT</code></a> that is performed by
            <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> to retrieve the table contents
            to obtain incorrect contents or fail.
          </p><p>
            <a class="link" href="mysqlpump.html#option_mysqlpump_add-locks"><code class="option">--add-locks</code></a> and
            <a class="link" href="mysqlpump.html#option_mysqlpump_single-transaction"><code class="option">--single-transaction</code></a> are
            mutually exclusive.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_skip-definer"></a>
            <a class="indexterm" name="idm139663283176864"></a>

            <a class="indexterm" name="idm139663283175376"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_skip-definer"><code class="option">--skip-definer</code></a>
          </p><p>
            Omit <code class="literal">DEFINER</code> and <code class="literal">SQL
            SECURITY</code> clauses from the
            <code class="literal">CREATE</code> statements for views and stored
            programs. The dump file, when reloaded, creates objects that
            use the default <code class="literal">DEFINER</code> and <code class="literal">SQL
            SECURITY</code> values. See
            <a class="xref" href="stored-objects-security.html" title="24.6 Stored Object Access Control">Section 24.6, “Stored Object Access Control”</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_skip-dump-rows"></a>
            <a class="indexterm" name="idm139663283166720"></a>

            <a class="indexterm" name="idm139663283165232"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_skip-dump-rows"><code class="option">--skip-dump-rows</code></a>,
            <code class="option">-d</code>
          </p><p>
            Do not dump table rows.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_socket"></a>
            <a class="indexterm" name="idm139663283160752"></a>

            <a class="indexterm" name="idm139663283159296"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_socket"><code class="option">--socket=<em class="replaceable"><code>path</code></em></code></a>,
            <code class="option">-S <em class="replaceable"><code>path</code></em></code>
          </p><p>
            For connections to <code class="literal">localhost</code>, the Unix
            socket file to use, or, on Windows, the name of the named
            pipe to use.
          </p><p>
            On Windows, this option applies only if the server was
            started with the <a class="link" href="server-system-variables.html#sysvar_named_pipe"><code class="literal">named_pipe</code></a>
            system variable enabled to support named-pipe connections.
            In addition, the user making the connection must be a member
            of the Windows group specified by the
            <a class="link" href="server-system-variables.html#sysvar_named_pipe_full_access_group"><code class="literal">named_pipe_full_access_group</code></a>
            system variable.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_ssl"></a>
            <a class="indexterm" name="idm139663283150288"></a>

            <a class="indexterm" name="idm139663283148832"></a>

            <code class="option">--ssl*</code>
          </p><p>
            Options that begin with
            <a class="link" href="connection-options.html#option_general_ssl"><code class="option">--ssl</code></a> specify whether to
            connect to the server using SSL and indicate where to find
            SSL keys and certificates. See
            <a class="xref" href="connection-options.html#encrypted-connection-options" title="Command Options for Encrypted Connections">Command Options for Encrypted Connections</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_ssl-fips-mode"></a>
            <a class="link" href="mysqlpump.html#option_mysqlpump_ssl-fips-mode"><code class="option">--ssl-fips-mode={OFF|ON|STRICT}</code></a>
          </p><a class="indexterm" name="idm139663283142352"></a><p>
            Controls whether to enable FIPS mode on the client side. The
            <a class="link" href="mysqlpump.html#option_mysqlpump_ssl-fips-mode"><code class="option">--ssl-fips-mode</code></a> option
            differs from other
            <code class="option">--ssl-<em class="replaceable"><code>xxx</code></em></code>
            options in that it is not used to establish encrypted
            connections, but rather to affect which cryptographic
            operations are permitted. See <a class="xref" href="fips-mode.html" title="6.5 FIPS Support">Section 6.5, “FIPS Support”</a>.
          </p><p>
            These <a class="link" href="mysqlpump.html#option_mysqlpump_ssl-fips-mode"><code class="option">--ssl-fips-mode</code></a>
            values are permitted:
</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: circle; "><li class="listitem"><p>
                <code class="literal">OFF</code>: Disable FIPS mode.
              </p></li><li class="listitem"><p>
                <code class="literal">ON</code>: Enable FIPS mode.
              </p></li><li class="listitem"><p>
                <code class="literal">STRICT</code>: Enable <span class="quote">“<span class="quote">strict</span>”</span>
                FIPS mode.
</p></li></ul>
</div>
<div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
<div class="admon-title">
Note
</div>
<p>
              If the OpenSSL FIPS Object Module is not available, the
              only permitted value for
              <a class="link" href="mysqlpump.html#option_mysqlpump_ssl-fips-mode"><code class="option">--ssl-fips-mode</code></a> is
              <code class="literal">OFF</code>. In this case, setting
              <a class="link" href="mysqlpump.html#option_mysqlpump_ssl-fips-mode"><code class="option">--ssl-fips-mode</code></a> to
              <code class="literal">ON</code> or <code class="literal">STRICT</code> causes
              the client to produce a warning at startup and to operate
              in non-FIPS mode.
</p>
</div>
</li><li class="listitem"><p><a name="option_mysqlpump_tls-ciphersuites"></a>
            <a class="indexterm" name="idm139663283125232"></a>

            <a class="indexterm" name="idm139663283123744"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_tls-ciphersuites"><code class="option">--tls-ciphersuites=<em class="replaceable"><code>ciphersuite_list</code></em></code></a>
          </p><p>
            The permissible TLSv1.3 ciphersuites for encrypted
            connections. The value is a list of one or more
            colon-separated ciphersuite names. The ciphersuites that can
            be named for this option depend on the SSL library used to
            compile MySQL. For details, see
            <a class="xref" href="encrypted-connection-protocols-ciphers.html" title="6.3.5 Encrypted Connection Protocols and Ciphers">Section 6.3.5, “Encrypted Connection Protocols and Ciphers”</a>.
          </p><p>
            This option was added in MySQL 8.0.16.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_tls-version"></a>
            <a class="indexterm" name="idm139663283117952"></a>

            <a class="indexterm" name="idm139663283116464"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_tls-version"><code class="option">--tls-version=<em class="replaceable"><code>protocol_list</code></em></code></a>
          </p><p>
            The permissible TLS protocols for encrypted connections. The
            value is a list of one or more comma-separated protocol
            names. The protocols that can be named for this option
            depend on the SSL library used to compile MySQL. For
            details, see
            <a class="xref" href="encrypted-connection-protocols-ciphers.html" title="6.3.5 Encrypted Connection Protocols and Ciphers">Section 6.3.5, “Encrypted Connection Protocols and Ciphers”</a>.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_triggers"></a>
            <a class="indexterm" name="idm139663283111152"></a>

            <a class="indexterm" name="idm139663283109664"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_triggers"><code class="option">--triggers</code></a>
          </p><p>
            Include triggers for each dumped table in the output.
          </p><p>
            This option is enabled by default; use
            <a class="link" href="mysqlpump.html#option_mysqlpump_triggers"><code class="option">--skip-triggers</code></a>
            to disable it.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_tz-utc"></a>
            <a class="indexterm" name="idm139663283104080"></a>

            <a class="indexterm" name="idm139663283102624"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_tz-utc"><code class="option">--tz-utc</code></a>
          </p><p>
            This option enables <a class="link" href="datetime.html" title="11.3.1 The DATE, DATETIME, and TIMESTAMP Types"><code class="literal">TIMESTAMP</code></a>
            columns to be dumped and reloaded between servers in
            different time zones. <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> sets its
            connection time zone to UTC and adds <code class="literal">SET
            TIME_ZONE='+00:00'</code> to the dump file. Without this
            option, <a class="link" href="datetime.html" title="11.3.1 The DATE, DATETIME, and TIMESTAMP Types"><code class="literal">TIMESTAMP</code></a> columns are
            dumped and reloaded in the time zones local to the source
            and destination servers, which can cause the values to
            change if the servers are in different time zones.
            <a class="link" href="mysqlpump.html#option_mysqlpump_tz-utc"><code class="option">--tz-utc</code></a> also protects
            against changes due to daylight saving time.
          </p><p>
            This option is enabled by default; use
            <a class="link" href="mysqlpump.html#option_mysqlpump_tz-utc"><code class="option">--skip-tz-utc</code></a>
            to disable it.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_user"></a>
            <a class="indexterm" name="idm139663283091280"></a>

            <a class="indexterm" name="idm139663283089824"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_user"><code class="option">--user=<em class="replaceable"><code>user_name</code></em></code></a>,
            <code class="option">-u <em class="replaceable"><code>user_name</code></em></code>
          </p><p>
            The user name of the MySQL account to use for connecting to
            the server.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_users"></a>
            <a class="indexterm" name="idm139663283084672"></a>

            <a class="indexterm" name="idm139663283083216"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_users"><code class="option">--users</code></a>
          </p><p>
            Dump user accounts as logical definitions in the form of
            <a class="link" href="create-user.html" title="13.7.1.3 CREATE USER Syntax"><code class="literal">CREATE USER</code></a> and
            <a class="link" href="grant.html" title="13.7.1.6 GRANT Syntax"><code class="literal">GRANT</code></a> statements.
          </p><p>
            User definitions are stored in the grant tables in the
            <code class="literal">mysql</code> system database. By default,
            <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> does not include the grant
            tables in <code class="literal">mysql</code> database dumps. To dump
            the contents of the grant tables as logical definitions, use
            the <a class="link" href="mysqlpump.html#option_mysqlpump_users"><code class="option">--users</code></a> option and
            suppress all database dumping:
          </p><pre class="programlisting copytoclipboard line-numbers language-terminal one-line"><code class="language-terminal">shell&gt; mysqlpump --exclude-databases=% --users</code></pre></li><li class="listitem"><p><a name="option_mysqlpump_version"></a>
            <a class="indexterm" name="idm139663283070656"></a>

            <a class="indexterm" name="idm139663283069168"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_version"><code class="option">--version</code></a>,
            <code class="option">-V</code>
          </p><p>
            Display version information and exit.
          </p></li><li class="listitem"><p><a name="option_mysqlpump_watch-progress"></a>
            <a class="indexterm" name="idm139663283064672"></a>

            <a class="indexterm" name="idm139663283063184"></a>

            <a class="link" href="mysqlpump.html#option_mysqlpump_watch-progress"><code class="option">--watch-progress</code></a>
          </p><p>
            Periodically display a progress indicator that provides
            information about the completed and total number of tables,
            rows, and other objects.
          </p><p>
            This option is enabled by default; use
            <a class="link" href="mysqlpump.html#option_mysqlpump_watch-progress"><code class="option">--skip-watch-progress</code></a>
            to disable it.
</p></li></ul>
</div>
<h4><a name="mysqlpump-filtering"></a>mysqlpump Object Selection</h4>
<a class="indexterm" name="idm139663283057152"></a><p>
        <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> has a set of inclusion and
        exclusion options that enable filtering of several object types
        and provide flexible control over which objects to dump:
</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p>
            <a class="link" href="mysqlpump.html#option_mysqlpump_include-databases"><code class="option">--include-databases</code></a> and
            <a class="link" href="mysqlpump.html#option_mysqlpump_exclude-databases"><code class="option">--exclude-databases</code></a> apply
            to databases and all objects within them.
          </p></li><li class="listitem"><p>
            <a class="link" href="mysqlpump.html#option_mysqlpump_include-tables"><code class="option">--include-tables</code></a> and
            <a class="link" href="mysqlpump.html#option_mysqlpump_exclude-tables"><code class="option">--exclude-tables</code></a> apply to
            tables. These options also affect triggers associated with
            tables unless the trigger-specific options are given.
          </p></li><li class="listitem"><p>
            <a class="link" href="mysqlpump.html#option_mysqlpump_include-triggers"><code class="option">--include-triggers</code></a> and
            <a class="link" href="mysqlpump.html#option_mysqlpump_exclude-triggers"><code class="option">--exclude-triggers</code></a> apply
            to triggers.
          </p></li><li class="listitem"><p>
            <a class="link" href="mysqlpump.html#option_mysqlpump_include-routines"><code class="option">--include-routines</code></a> and
            <a class="link" href="mysqlpump.html#option_mysqlpump_exclude-routines"><code class="option">--exclude-routines</code></a> apply
            to stored procedures and functions. If a routine option
            matches a stored procedure name, it also matches a stored
            function of the same name.
          </p></li><li class="listitem"><p>
            <a class="link" href="mysqlpump.html#option_mysqlpump_include-events"><code class="option">--include-events</code></a> and
            <a class="link" href="mysqlpump.html#option_mysqlpump_exclude-events"><code class="option">--exclude-events</code></a> apply to
            Event Scheduler events.
          </p></li><li class="listitem"><p>
            <a class="link" href="mysqlpump.html#option_mysqlpump_include-users"><code class="option">--include-users</code></a> and
            <a class="link" href="mysqlpump.html#option_mysqlpump_exclude-users"><code class="option">--exclude-users</code></a> apply to
            user accounts.
</p></li></ul>
</div>
<p>
        Any inclusion or exclusion option may be given multiple times.
        The effect is additive. Order of these options does not matter.
      </p><p>
        The value of each inclusion and exclusion option is a list of
        comma-separated names of the appropriate object type. For
        example:
      </p><pre class="programlisting copytoclipboard line-numbers language-terminal"><code class="language-terminal">--exclude-databases=test,world
--include-tables=customer,invoice</code></pre><p>
        Wildcard characters are permitted in the object names:
</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p>
            <code class="literal">%</code> matches any sequence of zero or more
            characters.
          </p></li><li class="listitem"><p>
            <code class="literal">_</code> matches any single character.
</p></li></ul>
</div>
<p>
        For example,
        <a class="link" href="mysqlpump.html#option_mysqlpump_include-tables"><code class="option">--include-tables=t%,__tmp</code></a>
        matches all table names that begin with <code class="literal">t</code> and
        all five-character table names that end with
        <code class="literal">tmp</code>.
      </p><p>
        For users, a name specified without a host part is interpreted
        with an implied host of <code class="literal">%</code>. For example,
        <code class="literal">u1</code> and <code class="literal">u1@%</code> are
        equivalent. This is the same equivalence that applies in MySQL
        generally (see <a class="xref" href="account-names.html" title="6.2.4 Specifying Account Names">Section 6.2.4, “Specifying Account Names”</a>).
      </p><p>
        Inclusion and exclusion options interact as follows:
</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p>
            By default, with no inclusion or exclusion options,
            <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> dumps all databases (with
            certain exceptions noted in
            <a class="xref" href="mysqlpump.html#mysqlpump-restrictions" title="mysqlpump Restrictions">mysqlpump Restrictions</a>).
          </p></li><li class="listitem"><p>
            If inclusion options are given in the absence of exclusion
            options, only the objects named as included are dumped.
          </p></li><li class="listitem"><p>
            If exclusion options are given in the absence of inclusion
            options, all objects are dumped except those named as
            excluded.
          </p></li><li class="listitem"><p>
            If inclusion and exclusion options are given, all objects
            named as excluded and not named as included are not dumped.
            All other objects are dumped.
</p></li></ul>
</div>
<p>
        If multiple databases are being dumped, it is possible to name
        tables, triggers, and routines in a specific database by
        qualifying the object names with the database name. The
        following command dumps databases <code class="literal">db1</code> and
        <code class="literal">db2</code>, but excludes tables
        <code class="literal">db1.t1</code> and <code class="literal">db2.t2</code>:

</p><pre class="programlisting copytoclipboard line-numbers language-terminal one-line"><code class="language-terminal">shell&gt; mysqlpump --include-databases=db1,db2 --exclude-tables=db1.t1,db2.t2</code></pre><p>
      </p><p>
        The following options provide alternative ways to specify which
        databases to dump:
</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p>
            The <a class="link" href="mysqlpump.html#option_mysqlpump_all-databases"><code class="option">--all-databases</code></a> option
            dumps all databases (with certain exceptions noted in
            <a class="xref" href="mysqlpump.html#mysqlpump-restrictions" title="mysqlpump Restrictions">mysqlpump Restrictions</a>). It is equivalent
            to specifying no object options at all (the default
            <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> action is to dump everything).
          </p><p>
            <a class="link" href="mysqlpump.html#option_mysqlpump_include-databases"><code class="option">--include-databases=%</code></a> is
            similar to
            <a class="link" href="mysqlpump.html#option_mysqlpump_all-databases"><code class="option">--all-databases</code></a>, but
            selects all databases for dumping, even those that are
            exceptions for
            <a class="link" href="mysqlpump.html#option_mysqlpump_all-databases"><code class="option">--all-databases</code></a>.
          </p></li><li class="listitem"><p>
            The <a class="link" href="mysqlpump.html#option_mysqlpump_databases"><code class="option">--databases</code></a> option
            causes <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> to treat all name
            arguments as names of databases to dump. It is equivalent to
            an <a class="link" href="mysqlpump.html#option_mysqlpump_include-databases"><code class="option">--include-databases</code></a>
            option that names the same databases.
</p></li></ul>
</div>
<h4><a name="mysqlpump-parallelism"></a>mysqlpump Parallel Processing</h4>
<a class="indexterm" name="idm139663282998880"></a><p>
        <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> can use parallelism to achieve
        concurrent processing. You can select concurrency between
        databases (to dump multiple databases simultaneously) and within
        databases (to dump multiple objects from a given database
        simultaneously).
      </p><p>
        By default, <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> sets up one queue with
        two threads. You can create additional queues and control the
        number of threads assigned to each one, including the default
        queue:
</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p>
            <a class="link" href="mysqlpump.html#option_mysqlpump_default-parallelism"><code class="option">--default-parallelism=<em class="replaceable"><code>N</code></em></code></a>
            specifies the default number of threads used for each queue.
            In the absence of this option, <em class="replaceable"><code>N</code></em>
            is 2.
          </p><p>
            The default queue always uses the default number of threads.
            Additional queues use the default number of threads unless
            you specify otherwise.
          </p></li><li class="listitem"><p>
            <a class="link" href="mysqlpump.html#option_mysqlpump_parallel-schemas"><code class="option">--parallel-schemas=[<em class="replaceable"><code>N</code></em>:]<em class="replaceable"><code>db_list</code></em></code></a>
            sets up a processing queue for dumping the databases named
            in <em class="replaceable"><code>db_list</code></em> and optionally
            specifies how many threads the queue uses.
            <em class="replaceable"><code>db_list</code></em> is a list of
            comma-separated database names. If the option argument
            begins with
            <code class="literal"><em class="replaceable"><code>N</code></em>:</code>, the queue
            uses <em class="replaceable"><code>N</code></em> threads. Otherwise, the
            <a class="link" href="mysqlpump.html#option_mysqlpump_default-parallelism"><code class="option">--default-parallelism</code></a>
            option determines the number of queue threads.
          </p><p>
            Multiple instances of the
            <a class="link" href="mysqlpump.html#option_mysqlpump_parallel-schemas"><code class="option">--parallel-schemas</code></a> option
            create multiple queues.
          </p><p>
            Names in the database list are permitted to contain the same
            <code class="literal">%</code> and <code class="literal">_</code> wildcard
            characters supported for filtering options (see
            <a class="xref" href="mysqlpump.html#mysqlpump-filtering" title="mysqlpump Object Selection">mysqlpump Object Selection</a>).
</p></li></ul>
</div>
<p>
        <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> uses the default queue for
        processing any databases not named explicitly with a
        <a class="link" href="mysqlpump.html#option_mysqlpump_parallel-schemas"><code class="option">--parallel-schemas</code></a> option, and
        for dumping user definitions if command options select them.
      </p><p>
        In general, with multiple queues, <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a>
        uses parallelism between the sets of databases processed by the
        queues, to dump multiple databases simultaneously. For a queue
        that uses multiple threads, <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> uses
        parallelism within databases, to dump multiple objects from a
        given database simultaneously. Exceptions can occur; for
        example, <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> may block queues while it
        obtains from the server lists of objects in databases.
      </p><p>
        With parallelism enabled, it is possible for output from
        different databases to be interleaved. For example,
        <a class="link" href="insert.html" title="13.2.6 INSERT Syntax"><code class="literal">INSERT</code></a> statements from multiple
        tables dumped in parallel can be interleaved; the statements are
        not written in any particular order. This does not affect
        reloading because output statements qualify object names with
        database names or are preceded by
        <a class="link" href="use.html" title="13.8.4 USE Syntax"><code class="literal">USE</code></a> statements as required.
      </p><p>
        The granularity for parallelism is a single database object. For
        example, a single table cannot be dumped in parallel using
        multiple threads.
      </p><p>
        Examples:
      </p><pre class="programlisting copytoclipboard line-numbers language-terminal one-line"><code class="language-terminal">shell&gt; mysqlpump --parallel-schemas=db1,db2 --parallel-schemas=db3</code></pre><p>
        <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> sets up a queue to process
        <code class="literal">db1</code> and <code class="literal">db2</code>, another queue
        to process <code class="literal">db3</code>, and a default queue to
        process all other databases. All queues use two threads.
      </p><pre class="programlisting copytoclipboard line-numbers language-terminal"><code class="language-terminal">shell&gt; mysqlpump --parallel-schemas=db1,db2 --parallel-schemas=db3
         --default-parallelism=4</code></pre><p>
        This is the same as the previous example except that all queues
        use four threads.
      </p><pre class="programlisting copytoclipboard line-numbers language-terminal one-line"><code class="language-terminal">shell&gt; mysqlpump --parallel-schemas=5:db1,db2 --parallel-schemas=3:db3</code></pre><p>
        The queue for <code class="literal">db1</code> and <code class="literal">db2</code>
        uses five threads, the queue for <code class="literal">db3</code> uses
        three threads, and the default queue uses the default of two
        threads.
      </p><p>
        As a special case, with
        <a class="link" href="mysqlpump.html#option_mysqlpump_default-parallelism"><code class="option">--default-parallelism=0</code></a> and no
        <a class="link" href="mysqlpump.html#option_mysqlpump_parallel-schemas"><code class="option">--parallel-schemas</code></a> options,
        <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> runs as a single-threaded process
        and creates no queues.
</p>
<h4><a name="mysqlpump-restrictions"></a>mysqlpump Restrictions</h4>
<a class="indexterm" name="idm139663282951136"></a><p>
        <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> does not dump the
        <code class="literal">performance_schema</code>,
        <code class="literal">ndbinfo</code>, or <code class="literal">sys</code> schema by
        default. To dump any of these, name them explicitly on the
        command line. You can also name them with the
        <a class="link" href="mysqlpump.html#option_mysqlpump_databases"><code class="option">--databases</code></a> or
        <a class="link" href="mysqlpump.html#option_mysqlpump_include-databases"><code class="option">--include-databases</code></a> option.
      </p><p>
        <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> does not dump the
        <code class="literal">INFORMATION_SCHEMA</code> schema.
      </p><p>
        <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> does not dump
        <code class="literal">InnoDB</code> <a class="link" href="create-tablespace.html" title="13.1.21 CREATE TABLESPACE Syntax"><code class="literal">CREATE
        TABLESPACE</code></a> statements.
      </p><p>
        <a class="link" href="mysqlpump.html" title="4.5.6 mysqlpump — A Database Backup Program"><span class="command"><strong>mysqlpump</strong></span></a> dumps user accounts in logical form
        using <a class="link" href="create-user.html" title="13.7.1.3 CREATE USER Syntax"><code class="literal">CREATE USER</code></a> and
        <a class="link" href="grant.html" title="13.7.1.6 GRANT Syntax"><code class="literal">GRANT</code></a> statements (for example,
        when you use the
        <a class="link" href="mysqlpump.html#option_mysqlpump_include-users"><code class="option">--include-users</code></a> or
        <a class="link" href="mysqlpump.html#option_mysqlpump_users"><code class="option">--users</code></a> option). For this
        reason, dumps of the <code class="literal">mysql</code> system database do
        not by default include the grant tables that contain user
        definitions: <code class="literal">user</code>, <code class="literal">db</code>,
        <code class="literal">tables_priv</code>, <code class="literal">columns_priv</code>,
        <code class="literal">procs_priv</code>, or
        <code class="literal">proxies_priv</code>. To dump any of the grant
        tables, name the <code class="literal">mysql</code> database followed by
        the table names:
      </p><pre class="programlisting copytoclipboard line-numbers language-terminal one-line"><code class="language-terminal">shell&gt; mysqlpump mysql user db ...</code></pre>
</div>
<br />
        </div>

                <div id="docs-in-page-nav-container">
            <div id="docs-in-page-nav">
                
    <a href="mysqlimport.html"
        aria-label="Previous" title="Previous: mysqlimport — A Data Import Program"><span
        class="icon-chevron-left"></span> PREV</a> &nbsp;
<a href="index.html" aria-label="Start" title="Start"> HOME</a> &nbsp;
        <a aria-label="Up" href="programs-client.html" title="Up: MySQL Client Programs"> UP</a> &nbsp;
    <a href="mysqlshow.html" aria-label="Next"
        title="Next: mysqlshow — Display Database, Table, and Column Information">NEXT <span
        class="icon-chevron-right"></span></a>
            </div>
        </div>
        
         <div id="docs-body-extra">
             
<a class="docs-sidebar-section" href=""><span class="icon-related"></span>
    <span class="text">Related Documentation</span></a>
<div class="docs-sidebar-accordian">
    <div class="text">
        <a href="/doc/relnotes/mysql/8.0/en/">MySQL 8.0 Release Notes</a><br />
        <a href="/doc/dev/mysql-server/latest/">MySQL 8.0 Source Code Documentation</a><br />
        </div>
</div>

    <a class="docs-sidebar-section" href=""><span class="icon-download-thin"></span>
        <span class="text">
            Download
                            this Manual
                    </span>
    </a>
    <div class="docs-sidebar-accordian">
        <div class="text">
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.pdf">PDF (US Ltr)</a>
            - 46.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.a4.pdf">PDF (A4)</a>
            - 46.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-ref-manual-8.0-en-pdf-1-20190611.noarch.rpm">PDF (RPM)</a>
            - 41.5Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.html-chapter.tar.gz">HTML Download (TGZ)</a>
            - 10.6Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.html-chapter.zip">HTML Download (Zip)</a>
            - 10.6Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-ref-manual-8.0-en-html-chapter-1-20190611.noarch.rpm">HTML Download (RPM)</a>
            - 9.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.man-gpl.tar.gz">Man Pages (TGZ)</a>
            - 220.4Kb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.man-gpl.zip">Man Pages (Zip)</a>
            - 325.8Kb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-8.0.info.gz">Info (Gzip)</a>
            - 4.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-8.0.info.zip">Info (Zip)</a>
            - 4.1Mb<br />
                    </div>
    </div>

<a class="docs-sidebar-section" href=""><span class="icon-book"></span>
    <span class="text">Excerpts from this Manual</span></a>
<div class="docs-sidebar-accordian">
    <div class="text">
                <a href="/doc/mysql-backup-excerpt/8.0/en/">MySQL Backup and Recovery</a><br />
                <a href="/doc/mysql-g11n-excerpt/8.0/en/">MySQL Globalization</a><br />
                <a href="/doc/mysql-infoschema-excerpt/8.0/en/">MySQL Information Schema</a><br />
                <a href="/doc/mysql-installation-excerpt/8.0/en/">MySQL Installation Guide</a><br />
                <a href="/doc/mysql-security-excerpt/8.0/en/">Security in MySQL</a><br />
                <a href="/doc/mysql-startstop-excerpt/8.0/en/">Starting and Stopping MySQL</a><br />
                <a href="/doc/mysql-linuxunix-excerpt/8.0/en/">MySQL and Linux/Unix</a><br />
                <a href="/doc/mysql-windows-excerpt/8.0/en/">MySQL and Windows</a><br />
                <a href="/doc/mysql-osx-excerpt/8.0/en/">MySQL and OS X</a><br />
                <a href="/doc/mysql-solaris-excerpt/8.0/en/">MySQL and Solaris</a><br />
                <a href="/doc/mysql-sourcebuild-excerpt/8.0/en/">Building MySQL from Source</a><br />
                <a href="/doc/mysql-reslimits-excerpt/8.0/en/">MySQL Restrictions and Limitations</a><br />
                <a href="/doc/mysql-partitioning-excerpt/8.0/en/">MySQL Partitioning</a><br />
                <a href="/doc/mysql-secure-deployment-guide/8.0/en/">MySQL Secure Deployment Guide</a><br />
                <a href="/doc/mysql-tutorial-excerpt/8.0/en/">MySQL Tutorial</a><br />
                <a href="/doc/mysql-perfschema-excerpt/8.0/en/">MySQL Performance Schema</a><br />
                <a href="/doc/mysql-replication-excerpt/8.0/en/">MySQL Replication</a><br />
                <a href="/doc/mysql-repo-excerpt/8.0/en/">Using the MySQL Yum Repository</a><br />
            </div>
</div>
         </div>

              </div>
     </div>

</div>

<script>
$(function() {
    var doc = new $.doc({ 'mobile': $.browser.mobile, 'docId': 1, 'highlight': true });
});
</script>
    

            
        </div>
    </div>

    <footer class="collapsed">
        <div id="footer-bottom">
                                    <div id="footer-collapse">
                <a href="" id="expand-footer"
                    aria-label="Expand Footer"
                    title="Expand Footer"><span
                    class="icon-plus-square"></span></a>
            </div>
                        <div class="footer-contact">
                <div id="footer-contact-icon" style="display: none;">
                    <span class="icon-call-phone"></span>
                </div>
                <div id="footer-contact-numbers" style="display: none;">
                    <strong>Contact MySQL Sales</strong><br/>
                    USA/Canada: +1-866-221-0634 &nbsp;
                    (<a href="https://www.mysql.com/about/contact/phone/">More Countries &raquo;</a>)
                </div>
                <div id="footer-contact-copyright" style="display: inline-block;">
                    <a href="http://www.oracle.com/" aria-label="Oracle" title="Oracle"><span class="oracle-logo"></span></a>
                    &nbsp; &copy; 2019, Oracle Corporation and/or its affiliates
                </div>
            </div>
            <div class="social-icons">
                <a aria-label="Join us on Facebook" title="Join us on Facebook" href="http://www.facebook.com/mysql"><span class="icon-facebook-square"></span></a>
                <a aria-label="Follow us on Twitter" title="Follow us on Twitter" href="https://twitter.com/mysql"><span class="icon-twitter-square"></span></a>
                <a aria-label="Follow us on LinkedIn" title="Follow us on LinkedIn" href="https://www.linkedin.com/company/mysql"><span class="icon-linkedin-square"></span></a>
                <a aria-label="Visit our YouTube channel" title="Visit our YouTube channel" href="http://www.youtube.com/mysqlchannel"><span class="icon-youtube-square"></span></a>
            </div>
            <br class="clear" />
        </div>
        <div id="footer-links">

            <div id="footer-nav"></div>

            <div class="links">
                <ul>
                    <li class="top"><a href="https://www.mysql.com/products/">Products</a></li>
                    <li><a href="https://www.mysql.com/cloud/">Oracle MySQL Cloud Service</a></li>
                    <li><a href="https://www.mysql.com/products/enterprise/">MySQL Enterprise Edition</a></li>
                    <li><a href="https://www.mysql.com/products/standard/">MySQL Standard Edition</a></li>
                    <li><a href="https://www.mysql.com/products/classic/">MySQL Classic Edition</a></li>
                    <li><a href="https://www.mysql.com/products/cluster/">MySQL Cluster CGE</a></li>
                    <li><a href="https://www.mysql.com/oem/">MySQL Embedded (OEM/ISV)</a></li>
                </ul>
            </div>

            <div class="links">
                <ul>
                    <li class="top"><a href="https://www.mysql.com/services/">Services</a></li>
                    <li><a href="https://www.mysql.com/training/">Training</a></li>
                    <li><a href="https://www.mysql.com/certification/">Certification</a></li>
                    <li><a href="https://www.mysql.com/consulting/">Consulting</a></li>
                    <li><a href="https://www.mysql.com/support/">Support</a></li>
                </ul>
            </div>

            <div class="links">
                <ul>
                    <li class="top"><a href="https://dev.mysql.com/downloads/">Downloads</a></li>
                    <li><a href="https://dev.mysql.com/downloads/mysql/">MySQL Community Server</a></li>
                    <li><a href="https://dev.mysql.com/downloads/cluster/">MySQL NDB Cluster</a></li>
                    <li><a href="https://dev.mysql.com/downloads/shell/">MySQL Shell</a></li>
                    <li><a href="https://dev.mysql.com/downloads/router/">MySQL Router</a></li>
                    <li><a href="https://dev.mysql.com/downloads/workbench/">MySQL Workbench</a></li>
                </ul>
            </div>

            <div class="links">
                <ul>
                    <li class="top"><a href="https://dev.mysql.com/doc/">Documentation</a></li>
                    <li><a href="https://dev.mysql.com/doc/refman/en/">MySQL Reference Manual</a></li>
                    <li><a href="https://dev.mysql.com/doc/workbench/en/">MySQL Workbench</a></li>
                    <li><a href="https://dev.mysql.com/doc/index-cluster.html">MySQL NDB Cluster</a></li>
                    <li><a href="https://dev.mysql.com/doc/index-connectors.html">MySQL Connectors</a></li>
                    <li><a href="https://dev.mysql.com/doc/#topic">Topic Guides</a></li>
                </ul>
            </div>

            <div class="links">
                <ul>
                    <li class="top"><a href="https://www.mysql.com/about/">About MySQL</a></li>
                    <li><a href="https://www.mysql.com/about/contact/">Contact Us</a></li>
                                                            <li><a href="https://www.mysql.com/buy-mysql/">How to Buy</a></li>
                    <li><a href="https://www.mysql.com/partners/">Partners</a></li>
                    <li><a href="https://www.mysql.com/about/jobs/">Job Opportunities</a></li>
                    <li><a href="https://www.mysql.com/sitemap.html">Site Map</a></li>
                </ul>
            </div>

            
            <div id="footer-logo">
                <a href="http://www.oracle.com/" aria-label="Oracle" title="Oracle"><span class="oracle-logo"></span></a>
                &nbsp; &copy; 2019, Oracle Corporation and/or its affiliates
                <div class="footer-legal-links">
                    <a href="https://www.mysql.com/about/legal/">Legal Policies</a> |
                    <a href="http://www.oracle.com/us/legal/privacy/index.htm">Your Privacy Rights</a> |
                    <a href="http://www.oracle.com/us/legal/terms/index.html">Terms of Use</a> |
                    <a href="http://www.oracle.com/us/legal/third-party-trademarks/index.html">Trademark Policy</a> |
                    <a href="http://www.oracle.com/technetwork/community/oca-486395.html">Contributor Agreement</a> |
                    <div id="teconsent" style="display: inline-block"><script async="async" type="text/javascript" src="js/notice.js" crossorigin=""></script></div>
                </div>
            </div>

        </div>
    </footer>
</div>

        <script src="js/s_code_remote.js"></script>

        
    
</body>
</html>
